Message-ID: <50C8DC4F.1040004@gmail.com>
Date: Wed, 12 Dec 2012 11:34:39 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: emilu@encs.concordia.ca
CC: pgsql-sql@postgresql.org
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
References: <50C8BB30.3000402@encs.concordia.ca> <50C8BFCC.4060100@gmail.com>
	<50C8C325.3070809@encs.concordia.ca>
In-Reply-To: <50C8C325.3070809@encs.concordia.ca>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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@utf8 to mysql@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.klaver@gmail.com


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