Emi Lu wrote on 13.12.2012 15:00:
Is there a simple way to load UTF8 data in psql to mysql(with latin1
encoding) through JDBC?
All you need to do is to query the source database, then use
ResultSet.getString() to obtain the data and use a PreparedStatement and
PreparedStatement.setString() to insert/update the data on the target
database.
The JDBC drivers will handle all the conversion.
Do NOT manually convert the data.
getString() and setString() will do everything correctly.
I am not using stmt directly but through Mybatis for all db transactions.
So, this approach will not work.
Then it's a problem of that MyBatis thing.
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
