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* Unicode just fine, but > it won't *know* it is Unicode. So if you just want raw data storage > it doesn't matter. If you would like to sort the data, upper-case > or lower-case it, or have automatic conversions to different client > encodings, you had better tell the server the truth about what it > is storing.
Thanx, i guess i didnt realize the value of conversion,sorting,etc... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- -Achilleus ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
