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:
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 ]
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

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.
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 

Will be fixed in 4.0.14