Subject Re: [firebird-support] What the difference between Charset NONE vs Charset Octets
Author Ann Harrison
On Wed, Feb 1, 2012 at 2:39 AM, nathanelrick <nathanelrick@...> wrote:
>
> I want to store the data in the database "as is"
> As i understand for the connection charset i have only the "NONE" choice, but for the field definition i can choose between "NONE" and "OCTETS" ... both are very similar as i understand, so much similar that i don't understand the difference between them ? with to choose ?
>

NONE leaves the data as a generic string which will be padded with
spaces when compared with longer strings. OCTETS declares that the
data is just bytes and will be padded with zeros when compared with
longer values.

Good luck,

Ann