Bug #6789 default-character-set option not reflected to character_set_system
Submitted: 24 Nov 2004 2:47 Modified: 24 Nov 2004 8:52
Reporter: Yusuke Naito Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.1.7 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[24 Nov 2004 2:47] Yusuke Naito
Using Japanese Windows XP, the option of default-character-set
for sjis reflects variables as follows.
| Variable_name            | Value            |
| character_set_client     | sjis             |
| character_set_connection | sjis             |
| character_set_database   | sjis             |
| character_set_results    | sjis             |
| character_set_server     | sjis             |
| character_set_system     | utf8             |
| collation_connection     | sjis_japanese_ci |
| collation_database       | sjis_japanese_ci |
| collation_server         | sjis_japanese_ci |

The character_set_system couldn't be reflected by the option 
on my.ini file.
This causes the database name,table name,column name character
set as utf8. The Japanese Windows uses sjis character
as system character, then utf8 names cannot be recognized from
file system. Until version 4.0.21, system character was sjis 
on Japanese Windows XP and the MyISAM files are not compatible
with 4.1.7.

How to repeat:
Set the option of default-character-set to sjis, execute
create table using sjis name, and view the MyISAM files
which cannot be read as Windows files.

Suggested fix:
The variable character_set_system should be reflected the
[24 Nov 2004 3:26] Paul DuBois
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

character_set_system is always utf8; you cannot
modify it.

[24 Nov 2004 8:52] Sergei Golubchik
See also http://bugs.mysql.com/bug.php?id=3906