Java and MySQL character sets

Drew Kutcharian <[email protected]>
Newsgroups gmane.comp.db.mysql.java
Message-ID <[email protected]> 
   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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.