Re: Load UTF8@psql into latin1@mysql through JDBC - Mailing list pgsql-sql

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;      }   }