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

[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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.