Bug #462 "SET CHARACTER SET DEFAULT" is not working
Submitted: 20 May 2003 11:39 Modified: 1 Jul 2003 5:11
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.13 OS:Any (All)
Assigned to: CPU Architecture:Any

[20 May 2003 11:39] [ name withheld ] 
Description:
If I change character set mapping with SET CHARACTER SET character set name,
I can't change it to DEFAULT (ie. disable mapping) with SET CHARACTER SET
DEFAULT.

How to repeat:
1) Install MySQL from binary distribution.
2) Look at "SHOW VARIABLES", variable "convert_character_set" is empty.
3) Execute "SET CHARACTER SET cp1251_koi8"
4) Look at "SHOW VARIABLES", variable "convert_character_set" is "cp1251_koi8". This is OK.
5) Execute "SET CHARACTER SET DEFAULT"
6) Look at "SHOW VARIABLES", variable "convert_character_set" is "cp1251_koi8". It should be empty like in point 2.

Suggested fix:
Sorry, dunno.
[22 May 2003 5:33] [ name withheld ] 
I tested it on FreeBSD 4.x and Windows XP. Same bug was in 4.0.12 and I didn't tested earlier 4.0.x versions. In 3.23.x character mapping can be disabled with SET CHARACTER SET DEFAULT without any problem.
[1 Jul 2003 5:11] Michael Widenius 
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html

Will be fixed in 4.0.14