MySQL Bugs: #24862: Access 2000 error linked table

Bug #24862	Access 2000 error linked table - field with french caracter
Submitted:	6 Dec 2006 18:42	Modified:	13 Sep 2007 21:57
Reporter:	Jean Choquette	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	5.1	OS:	Windows (WinXP)
Assigned to:		CPU Architecture:	Any

Description:
In Access 2000, I link on a MySQL table. In a text field, I enter a french character (é,è,ç, etc.) or an "'". When I try to insert/update/delete that record, I have an ODBC failed error. If I put two "'" side by side, I avoid the error (much like an usual hard-coded SQL query where we have to double every quote to make it work)

I tried on many tables with text fields and the error occured every time (number of fields doesn't change anything).

How to repeat:
Create a database in Access 2000
Link to one table with at least one text field in MySQL
Open linked table in MySQL and modify text field on existing/new record to update/insert a record. 

The error occurs when leaving record (on save).

Suggested fix:
Support french characters and other extended ASCII codes after 127

Hi Jean and thanks for your problem report. We are aware of this. Fix is planned for 5.00.10 release.

Thanks for your interest in MySQL!

We need to check whether 5.1 has this problem.

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Explanation: Hi Jean. This problem is fixed in new MyODBC 5.1 release and I tested it in Bug#27403.
You do not need to set any c-set related option in MyODBC for this to work.

A paste from Access 2003
Id	c1
1	Кириллица      Ukr. Cyrillic
2	Latin text     Latin1 text
3	šđčćžŠĐČĆŽ     Cro. text

Host OS: XP Pro SP2
MySQL server version: 4.1.22-log
mysql> show variables like "%char%";
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | utf8                     |
| character_set_connection | utf8                     |
| character_set_database   | utf8                     |
| character_set_results    | utf8                     |
| character_set_server     | utf8                     |
| character_set_system     | utf8                     |
| character_sets_dir       | C:\mysql\share\charsets/ |
+--------------------------+--------------------------+

| ttest | CREATE TABLE `čćšĐttestšđč` (
  `c1` varchar(20) default NULL,
  `Id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |