Bug #7220 information_schema: errors in "character_sets"
Submitted: 13 Dec 2004 1:39 Modified: 14 Dec 2004 11:06
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-alpha-debug OS:Linux (SUSE 9.2)
Assigned to: Sergei Glukhov CPU Architecture:Any

[13 Dec 2004 1:39] Peter Gulutzan 
Description:
The DESCRIPTION column should be at the end. 
In general, MySQL-extension columns should follow SQL-standard columns. 
I am aware that this means the result won't look like what 
SHOW CHARACTER SET produces. 
 

How to repeat:
mysql> select * from  information_schema.character_sets ; 
+--------------------+-----------------------------+----------------------+--------+ 
| CHARACTER_SET_NAME | DESCRIPTION                 | DEFAULT_COLLATE_NAME | 
MAXLEN | 
+--------------------+-----------------------------+----------------------+--------+ 
| big5               | Big5 Traditional Chinese    | big5_chinese_ci      |      2 | 
| dec8               | DEC West European           | dec8_swedish_ci      |      1 | 
...
[14 Dec 2004 11:06] Sergei Glukhov 
Fixed in 5.0 source tree