?s appearing when transfering data via JDBC from mySQL4.0 to mySQL4.1

[supun edirisinghe]

I have data being transfered from one database (mySQL 4.0) to another (mySQL4.1).

I'm selecting the data out into my jdbc driven java app from the mysql4.0 server and then executing an insert into the mySQL4.1 server. Data gets inserted but characters such as apostrophes and special characters (eg umlaut) get converted to question marks on the new server. Th character encoding of the 4.0 server is latin1_de and the character encoding of the 4.1 table that I'm inserting into is in latin1

I'm using Connector/J 3.0. After I select the data, I use java.sql.ResultSet's getString() method to get a string and then I insert that string straight into the new server using java.sql.Statement.execute("insert into...." )
is this a character encoding issue or a jdbc bug? Is it because the default encoding of mySQL 4.1 is UTF-8?

what is the best practice for transfering data from mysql4.0 to mysql4.1 via jdbc? Is there anything I should be weary of.

thanks