JAVA + MYSQL + ACCESS + ENCODING!!! help needed here!!!!
i have to migrate some data from access to mysql. however, i have some japanese characters in the access table and whenever i am done w/ migration and open the mysql table, i see bunch of ? instead japanese character. since im now working for a japanese company, this pc is in japanese eviorioment.
i set mysql table to use utf8. does anyone here know whats going wrong? i guess there is something to do w/ encoding stuff. please help!!!
here is some more information:
java1.5.1, access2003, mysql5.1 and japanese xp
This is the third thread you have opened on the same problem within the last couple of days, and you have not provided any more information than in the first one that would let people figure out what you are doing and thus help you.
In the first thread you opened it seems you had gotten to the point of realizing that you couldn't insert Japanese characters correctly in your mysql database, right? So it seems that the problem is simply with your mysql configuration and/or the way you interact with it from Java.
So, to narrow the problem down further:
1. Can you insert Japanese directly into mysql (not from Java) and get them rendered correctly? That would indicate your DB is configured correctly.
2. What is the code you use to insert Japanese characters into mysql? (start with hardcoded Japanese, don't mix the Access migration into this yet)
The problem is likely attributed to JDBC-ODBC bridge's inability to retrieve Unicode data from MS Access, rather than to writing Unicode data to MySQL.
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6345277
Try a third-party commercial JDBC driver (HXTT, JadoZoom, Easysoft, etc.) that supports Unicode for Access DBMS. If your database is simple, you can migrate data manually by exporting Access to UTF-8 text and then importing it into MySQL. See http://vietunicode.sourceforge.net/howto/ for how-to.
