Re: JDBC to load UTF8@psql to latin1@mysql - Mailing list pgsql-general

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