Re: [GENERAL] postgres & server encodings - Mailing list pgsql-admin

From Tom Lane
Subject Re: [GENERAL] postgres & server encodings
Date
Msg-id 16705.1123603167@sss.pgh.pa.us
Whole thread Raw
Responses Re: [GENERAL] postgres & server encodings
Re: [GENERAL] postgres & server encodings
List pgsql-admin
"Salem Berhanu" <salemb4@hotmail.com> writes:
> What exactly is the SQL_ASCII encoding in postgres?

SQL_ASCII isn't so much an encoding as the declaration that you don't
care about encodings.  That setting simply disables encoding validity
checks and encoding conversions.  The server will take any byte string
clients send it (barring only embedded zero bytes), and store and return
it unchanged.

Since it disables conversions, the notion of converting to another
encoding is pretty much meaningless :-(.

            regards, tom lane

pgsql-admin by date:

Previous
From: John DeSoi
Date:
Subject: Re: REVOKE from all tables ...
Next
From: "Joel Fradkin"
Date:
Subject: Re: [GENERAL] postgres & server encodings