Re: Load UTF8@psql into latin1@mysql through JDBC

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
Date: 2012-12-12 17:47:17
Message-ID: 50C8C325.3070809@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

>> 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(at)utf8 to mysql(at)latin1, the french character
cannot be auto-loaded.

Thanks.
--
Emi

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2012-12-12 18:06:57 Re: Load UTF8@psql into latin1@mysql through JDBC
Previous Message Adrian Klaver 2012-12-12 17:33:00 Re: Load UTF8@psql into latin1@mysql through JDBC