RE: Java and MySQL character sets

Hey,
	Here is a tiny fragment of what you may need from way back. To
(successfully) get Chinese in to MySQL I used this connection string.
The corresponding MySQL db / table(s) were I recall set to InnoDB.
          
String conString = "jdbc:mysql://" + Utils.getParam("db_host",
parentNode) + "/"
                    + Utils.getParam("db_name", parentNode) + "?user=" +
Utils.getParam("username", parentNode)
                    + "&password=" + Utils.getParam("password",
parentNode)
                    + "&characterEncoding=UTF-8";

connection = DriverManager.getConnection(conString);

I short, my solution was double ended. The character encoding required
setting on the connection string, and InnoDB on MySQL. Unicode was not
in the argument as Java supports Unicode as standard. 

That's all I can recall for my touch on multilingualism. Hope it points
you in the right direction. Or some can correct my inaccuracies here. 

Rgds

Paul.


   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
 

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]