Emi Lu wrote on 12.12.2012 17:17:
> Good morning,
>
> 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.
Thomas