Thread: Load UTF8@psql into latin1@mysql through JDBC
Good morning, Is there a simple way to load UTF8 data in psql to mysql(with latin1 encoding) through JDBC? Thanks a lot! Emi
On 12/12/2012 09:13 AM, Emi Lu wrote: > Good morning, > > Is there a simple way to load UTF8 data in psql to mysql(with latin1 > encoding) through JDBC? This would seem to be dependent on the MySQL JDBC adapter. From here: http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-charsets.html "All strings sent from the JDBC driver to the server are converted automatically from native Java Unicode form to the client character encoding, including all queries sent.... " > > Thanks a lot! > Emi > > -- Adrian Klaver adrian.klaver@gmail.com
>> Is there a simple way to load UTF8 data in psql to mysql(with latin1 >> encoding) through JDBC? > > This would seem to be dependent on the MySQL JDBC adapter. > >>From here: > > http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-charsets.html > > "All strings sent from the JDBC driver to the server are > converted automatically from native Java Unicode form to > the client character encoding, including all queries sent.... " This does not help. The reason I asked this is because through mybatis + JDBC, loading data from psql@utf8 to mysql@latin1, the french character cannot be auto-loaded. Thanks. -- Emi
On 12/12/2012 12:47 PM, Emi Lu wrote: >>> Is there a simple way to load UTF8 data in psql to mysql(with latin1 >>> encoding) through JDBC? >> >> This would seem to be dependent on the MySQL JDBC adapter. >> >>> From here: >> >> http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-charsets.html >> >> >> "All strings sent from the JDBC driver to the server are >> converted automatically from native Java Unicode form to >> the client character encoding, including all queries sent.... " > > This does not help. The reason I asked this is because through mybatis + > JDBC, loading data from psql@utf8 to mysql@latin1, the french character > cannot be auto-loaded. > JAVA codes work for most of characters, but not "-È". Someone knows why the following codes cannot load "-È" to mysql@latin1? Thanks a lot! -- public static String utf8_to_latin1(String str) throws Exception { try { String stringToConvert = str; byte[] convertStringToByte = stringToConvert.getBytes("UTF-8"); return new String(convertStringToByte,"ISO-8859-1"); }catch(Exception e) { log.error("utf8_to_latin1 Error: " + e.getMessage()); log.error(e); throw e; } }
On 12/12/2012 09:47 AM, Emi Lu wrote: >>> Is there a simple way to load UTF8 data in psql to mysql(with latin1 >>> encoding) through JDBC? >> >> This would seem to be dependent on the MySQL JDBC adapter. >> >>> From here: >> >> http://dev.mysql.com/doc/refman/5.1/en/connector-j-reference-charsets.html >> >> >> "All strings sent from the JDBC driver to the server are >> converted automatically from native Java Unicode form to >> the client character encoding, including all queries sent.... " > > This does not help. The reason I asked this is because through mybatis + > JDBC, loading data from psql@utf8 to mysql@latin1, the french character > cannot be auto-loaded. You might get an answer sooner at: https://groups.google.com/group/mybatis-user > > Thanks. > -- > Emi > > -- Adrian Klaver adrian.klaver@gmail.com