Bug #8492 Unicode support in MyODBC driver
Submitted: 13 Feb 2005 22:25 Modified: 16 Feb 2005 18:35
Reporter: Quan Nguyen Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51 OS:Microsoft Windows (Windows)
Assigned to: CPU Architecture:Any
Tags: ODBC5-RC

[13 Feb 2005 22:25] Quan Nguyen
Description:
Migrating Unicode text data from MS Access 2000/XP to MySQL 4.1 results in Unicode characters becoming '?'. There are heavy demands to migrate databases from Access containing Unicode characters to MySQL. The problem resolution will help accelerate the process. We're waiting for the release of MySQL Connector/ODBC 3.53.

How to repeat:
- Control Panel/Administrative Tools/Data Sources (ODBC) (WinXP)
- Select System DNS tab, click Add
- Select Driver MySQL ODBC 3.51 driver. Click Finish
- In Data Source Name, type XYZ (name of DNS)
- Host/Server Name:localhost (127.0.0.1)

- Launch Access and open database file
- Select table that needs export to MySQL
- Select File/Export
- In the dialog, select Save as Type as ODBC Databases
- Select Machine Data Source tab
- Select XYZ
- Select OK/Finish
[16 May 2006 11:49] Daniel Ma
Yes, we are facing the same problem when using ODBC 3.5.1 driver. It is claimed the 3.5.2 will resolve the issue but we are still waiting. Using PHP native drivers have no problem in retrieving the data for web pages.

Postgresql ODBC drivers already have a Unicode enabled version.