From: Emi Lu <emilu@encs.concordia.ca>
To: Adrian Klaver <adrian.klaver@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
Date: Wed, 12 Dec 2012 12:47:17 -0500
Message-ID: <50C8C325.3070809@encs.concordia.ca> (raw)
In-Reply-To: <50C8BFCC.4060100@gmail.com>
References: <50C8BB30.3000402@encs.concordia.ca>
<50C8BFCC.4060100@gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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@utf8 to mysql@latin1, the french character
cannot be auto-loaded.
Thanks.
--
Emi
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: emilu@encs.concordia.ca, adrian.klaver@gmail.com
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
In-Reply-To: <50C8C325.3070809@encs.concordia.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox