Bug #20520 MS Access contain Chinese
Submitted: 17 Jun 2006 15:23 Modified: 18 Jun 2006 15:40
Reporter: Patrick Ko Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Migration Toolkit Severity:S3 (Non-critical)
Version:1.0.25 OS:Windows (Windows XP Home version 2002 SP2)
Assigned to: Michael G. Zinner CPU Architecture:Any

[17 Jun 2006 15:23] Patrick Ko
Description:
Cannot convert MS Access 2000 successfully when it contains Chinese characters.

Tried to use multinational options of the migration toolkit but it does not work.  

How to repeat:
create any MS Access 2000 mdb file with TABLE names in Chinese and records in Chinese.
[18 Jun 2006 15:40] Michael G. Zinner
This issue has already been fixed in the source repository and will be included into the next release.

As a workaround, press the [Advanced >>] button on the page you specify the connection to the MySQL server and enter the JDBC connection string directly following this format.

jdbc:mysql://%host%:%port%/?user=%username%&password=%password%&useServerPrepStmts=false&characterEncoding=UTF-8

Please note the characterEncoding=UTF-8 at the end of the string that will fix the issue.
[17 Feb 2009 13:56] Wang Lei
I am from China, my OS is Windows XP Simplified Chinese Edition,
why i cannot migrate from access database? even if it does not contain any chinese characters.