Hi Drew,

UTF-8 is a unicode characterset, just as UTF-16, see http://www.joelonsoftware.com/articles/Unicode.html. The whole collation thing is explained here; http://dev.mysql.com/doc/refman/5.0/en/charset-general.html. You'll have to decide for yourself which of the unicode charsets, and which of the collations are best to use. It may depend on your input, sometimes its easier to take utf-8, as alot of web input/output is like that, but it varies...

Maarten

Drew Kutcharian wrote:
Hi everyone,

I am trying to develop an multi-language application that will use i18n. What is the best character set and collation to use with Java 5, JDBC and MySQL 5? There are way too many variations, UTF-8, UTF-16, UCS-2 for character codes, and a lot more collation types! I checked the Java specs and it says Java supports Unicode 4.0 but how does this map to MySQL??

Thanks,
Drew
------------------------------------------------------------------------

_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users

_______________________________________________
Rife-users mailing list
[email protected]
http://lists.uwyn.com/mailman/listinfo/rife-users

Reply via email to