Re: [GENERAL] postgres & server encodings

2005-08-09 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > "Salem Berhanu" <[EMAIL PROTECTED]> 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. It's too late to consider renaming this SQL_RAW or someth

Re: [GENERAL] postgres & server encodings

2005-08-09 Thread Lincoln Yeoh
At 05:59 PM 8/9/2005 +0200, Martijn van Oosterhout wrote: SQL_ASCII means that the database does no locale specific or language specific encoding ever. It won't check what you send it either. If you're content to let clients deal with any encoding issues, this may be what you want. But anything

Re: [GENERAL] postgres & server encodings

2005-08-09 Thread Tom Lane
Martijn van Oosterhout writes: > SQL_ASCII means that the database does no locale specific or language > specific encoding ever. It won't check what you send it either. If > you're content to let clients deal with any encoding issues, this may > be what you want. > But anything to do with lower()

Re: [GENERAL] postgres & server encodings

2005-08-09 Thread Martijn van Oosterhout
On Mon, Aug 08, 2005 at 04:10:50PM +, Salem Berhanu wrote: > What exactly is the SQL_ASCII encoding in postgres? I have a pg > installation with an SQL_ASCII server encoding and my database (also > SQL_ASCII) seems to be able to handle all types of encodings? how is this > possible? is this

Re: [GENERAL] postgres & server encodings

2005-08-09 Thread Tom Lane
"Salem Berhanu" <[EMAIL PROTECTED]> 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 b