Kwa Kil On Swa

Thursday, November 09, 2006

postgress unicode and latin-1 - Moral use unicode !

http://archives.postgresql.org/pgsql-jdbc/2004-11/msg00075.php

1. Create the database with the proper encoding.
In our experience, the best thing to do is simply choose Unicode as the database's character encoding if you think there's a chance of storing Latin1 or other characters. You could choose Latin1, and this should work in most cases. However, there are times when normal-looking characters refuse to be stored in a Latin1 database, such as character 239, which is the same in Latin1 as it is is Utf-8. Rather than attempt to beat our heads against this wall, we went with Unicode because it will hold whatever we need to hold.

0 Comments:

Post a Comment

<< Home