The encoding Latin1 would be the most appropriate, but 1252 is a superset of ISO8859-1 and supports more characters, and when I want to write them through odbc I get an error.
psqlodbc 8 converts everything to utf-8 and then sends it to the server.
I have a database with Latin1 encoding, the windows client code page is 1252 and for some characters I get
could not convert UTF-8 character 0x00e2 to ISO8859-1
A solution would be to use the UNICODE encoding in the database, but I have read that it's not safe on windows.
So, any ideas?
Andrei
-- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.9 - Release Date: 5/12/2005
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)