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

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.

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.

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

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.