MySQL Bugs: #8492: Unicode support in MyODBC driver

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:	Windows (Windows)
Assigned to:		CPU Architecture:	Any
Tags:	ODBC5-RC

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

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.