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

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

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(at)utf8 to mysql(at)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(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Wes James 2012-12-21 16:31:58 deciding on one of multiple results returned
Previous Message Emi Lu 2012-12-12 18:06:57 Re: Load UTF8@psql into latin1@mysql through JDBC