Bug #7901 default-character-set option is not applying to client connections
Submitted: 14 Jan 2005 10:30 Modified: 14 Jan 2005 11:48
Reporter: Alexander Kulikov Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.8 OS:
Assigned to: CPU Architecture:Any

[14 Jan 2005 10:30] Alexander Kulikov
Description:
"default-character-set" option is not applying to "character_set_client", "character_set_connection", "character_set_results" variables.
And there is no way to change default values of this variables.

How to repeat:
1. Run server width

[mysqld]
default-character-set=cp1251
default-collation=cp1251_general_ci

in my.cnf file.

2. Run 'echo "show variables like '%character%';" |mysql'

Result is 

Variable_name   Value
character_set_client    latin1
character_set_connection        latin1
character_set_database  cp1251
character_set_results   latin1
character_set_server    cp1251
character_set_system    utf8
character_sets_dir      /usr/share/mysql/charsets/
[14 Jan 2005 11:48] MySQL Verification Team
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