Bug #4489 French characters in columns names
Submitted: 9 Jul 2004 18:37 Modified: 26 Jul 2004 18:56
Reporter: Francis Lennert Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.X OS:Windows (Windows 2000/2003)
Assigned to: Bugs System CPU Architecture:Any

[9 Jul 2004 18:37] Francis Lennert
Description:
Troubles With the names of columns :

You have one columns or more which used some french characters in version 4.0.20 like :
Create table MyTable (

Données Text ,
Amitié     Text,
)

insert into MyTable values ( 'AAAA', 'BBB')

and then upgrade to Version 4.1.x

Once you do that, with MyOdbc Version 2.5.x you can't retrieve the values: Mysql generates an error message.

How to repeat:
Cf. Description.

Suggested fix:
Well, well, I don't know !!! But I'am sure that you will find how to do that.

Or, have some good users who are not stupids like me and don't use French Characters in the tables definitions.
[13 Jul 2004 12:46] Hartmut Holzgraefe
Verified with 4.1.3 / Linux

Table names are now always stored as UTF8 internally,
no matter what the default character set is.

The "Upgrading from 4.0 to 4.1" manual section should mention this
[26 Jul 2004 18:56] Paul DuBois
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).