Re: JDBC to load UTF8@psql to latin1@mysql - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: JDBC to load UTF8@psql to latin1@mysql
Date
Msg-id CA+6hpanviWn_m2n=qghEsP3ipq8hVoW64v9ta79XkwQ8=t7tPQ@mail.gmail.com
Whole thread Raw
In response to Re: JDBC to load UTF8@psql to latin1@mysql  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: JDBC to load UTF8@psql to latin1@mysql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> The JDBC drivers will handle all the conversion.
> Do NOT manually convert the data.

Yeah, I agree this is the right answer here, since you're using JDBC. By the time you get a String from the MySQL driver, it's already in Java's 2-bytes-per-char format. And the Postgres driver will deal with the encoding on the output side. So the code I provided won't help you. I'm afraid I don't know about Mybatis, but if it's built on JDBC I'd think you've just got a configuration problem with what encoding the client expects at either end.

Paul


--
_________________________________
Pulchritudo splendor veritatis.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: initdb error
Next
From: Amitabh Kant
Date:
Subject: Re: initdb error