Em 13/12/2012 12:00, Emi Lu escreveu:
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.
Should not this a Mybatis problem instead?
As stated, JDBC drivers does all the conversion needed automatically,
but if you have a middleware messing with your enconding, then the
problem is the middleware, not databases or drivers.
Edson
So, this approach will not work.
Thanks.
--
Emi
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
