pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@gmail.com>
To: emilu@encs.concordia.ca
Cc: pgsql-sql@postgresql.org
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
Date: Wed, 12 Dec 2012 11:34:39 -0800
Message-ID: <50C8DC4F.1040004@gmail.com> (raw)
In-Reply-To: <50C8C325.3070809@encs.concordia.ca>
References: <50C8BB30.3000402@encs.concordia.ca>
	<50C8BFCC.4060100@gmail.com>
	<50C8C325.3070809@encs.concordia.ca>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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@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



view thread (5+ messages)

Message-ID: <50C8DC4F.1040004@gmail.com>
Permalink:  ../50C8DC4F.1040004@gmail.com/
Also on:    postgresql.org/message-id/50C8DC4F.1040004@gmail.com

 · 

reply

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: adrian.klaver@gmail.com, emilu@encs.concordia.ca
  Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
  In-Reply-To: <50C8DC4F.1040004@gmail.com>

* 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