Re: JDBC to load UTF8@psql to latin1@mysql

[Emi Lu <emilu@xxxxxxxxxxxxxxxxx>]

> Is there a simple way to load UTF8 data in psql to mysql(with latin1
> encoding) through JDBC?
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;
      }
   }


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general