Bug #39877 Problem with ä,ü,ö after Upgrade from MySQL Version 4.0.24 to Version 5.0.45
Submitted: 6 Oct 2008 10:03 Modified: 7 Oct 2008 9:03
Reporter: Andre Iselin Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.45 OS:Windows
Assigned to: CPU Architecture:Any

[6 Oct 2008 10:03] Andre Iselin
Description:
Hallo,

I have a problem with ä,ü,ö after Upgrade from MySQL Version 4.0.24 to Version 5.0.45. I changed the character variables to latin1 except the character_set_system variable (this variable is read only) but I can not connect to the tables that have a name with a character ä,ü,ö at the attribute column. If I use the mysql client to connect to the database I have no problem to select the tables with ä,ö,ü at the attribute column. Every time I connect to the database via odbc or a other software I could'nt see any data of the tables or I can see the name with an ? or ´´ character.

Can you give me any advice about this problem?

How to repeat:
Change a database from a version 4 to 5 with ä,üö at the attribute column.
[7 Oct 2008 9:03] Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Since version 4.1 character set support has been completely rewritten. You need to start reading from http://dev.mysql.com/doc/refman/4.1/en/charset.html for understanding how it works now and how to upgrade from earlier versions properly.