MySQL Bugs: #6789: default-character-set option not reflected to character_set

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:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S2 (Serious)
Version:	4.1.7	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
mysql> SHOW VARIABLES;
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
default-character-set.

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.

http://dev.mysql.com/doc/mysql/en/Server_system_variables.html

See also http://bugs.mysql.com/bug.php?id=3906