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 17:33:00
Message-ID: 50C8BFCC.4060100@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 12/12/2012 09:13 AM, Emi Lu wrote:
> Good morning,
>
> 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.... "

>
> Thanks a lot!
> Emi
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2012-12-12 17:47:17 Re: Load UTF8@psql into latin1@mysql through JDBC
Previous Message Emi Lu 2012-12-12 17:13:20 Load UTF8@psql into latin1@mysql through JDBC