Re: [SQL] SQL_ASCII and UNICODE server_encoding

2004-08-16 Thread Achilleus Mantzios
O kyrios Tom Lane egrapse stis Aug 16, 2004 : > Achilleus Mantzios <[EMAIL PROTECTED]> writes: > > So if SQL_ASCII should be fine for UTF-8 storage. > > (here i must have missed something, tho..), whats > > the purpose of server_encoding=UNICODE? > > If you use SQL_ASCII, the server will *store*

Re: [SQL] SQL_ASCII and UNICODE server_encoding

2004-08-16 Thread Tom Lane
Achilleus Mantzios <[EMAIL PROTECTED]> writes: > So if SQL_ASCII should be fine for UTF-8 storage. > (here i must have missed something, tho..), whats > the purpose of server_encoding=UNICODE? If you use SQL_ASCII, the server will *store* Unicode just fine, but it won't *know* it is Unicode. So i

[SQL] SQL_ASCII and UNICODE server_encoding

2004-08-16 Thread Achilleus Mantzios
Hi, i'd like to ask if there is any difference in server_encoding SQL_ASCII and UNICODE (there must be one since the different terms), but AFAIU -databases which store in SQL_ASCII (i.e. server_encoding=SQL_ASCII) have no problem storing 8bit chars with the first bit set. -databases with server