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