Re: JDBC to load UTF8@psql to latin1@mysql
| От | Paul Jungwirth |
|---|---|
| Тема | Re: JDBC to load UTF8@psql to latin1@mysql |
| Дата | |
| Msg-id | CA+6hpanviWn_m2n=qghEsP3ipq8hVoW64v9ta79XkwQ8=t7tPQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: JDBC to load UTF8@psql to latin1@mysql (Emi Lu <emilu@encs.concordia.ca>) |
| Ответы |
Re: JDBC to load UTF8@psql to latin1@mysql
|
| Список | 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.
> 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 по дате отправления: