?s appearing when transfering data via JDBC from mySQL4.0 to mySQL4.1
Posted by: supun edirisinghe
Date: April 20, 2005 09:33PM

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.


Options: ReplyQuote

Written By
?s appearing when transfering data via JDBC from mySQL4.0 to mySQL4.1
April 20, 2005 09:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.