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

From Tom Lane
Subject Re: JDBC to load UTF8@psql to latin1@mysql
Date
Msg-id 11655.1355433207@sss.pgh.pa.us
Whole thread Raw
In response to Re: JDBC to load UTF8@psql to latin1@mysql  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: JDBC to load UTF8@psql to latin1@mysql  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-general
Paul Jungwirth <pj@illuminatedcomputing.com> writes:
> 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.

I was wondering if the problem wasn't lots simpler than that.  Is the
character the OP is trying to convert actually part of LATIN1?

            regards, tom lane


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: How to keep the last row of a data set?
Next
From: Chris Angelico
Date:
Subject: Re: How to keep the last row of a data set?