Bug #6690 SHOW CREATE TABLE reports CHARACTER SET attribute inconsistently
Submitted: 17 Nov 2004 22:06 Modified: 1 Dec 2004 12:20
Reporter: Paul Dubois Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.x OS:
Assigned to: Alexander Barkov CPU Architecture:Any

[17 Nov 2004 22:06] Paul Dubois
Description:
SHOW CREATE TABLE reports the CHARACTER SET
attribute one way for columns and another way
for table options.

How to repeat:
mysql> CREATE TABLE t (c CHAR CHARACTER SET latin1) CHARACTER SET utf8;
Query OK, 0 rows affected (0.07 sec)

mysql> SHOW CREATE TABLE t\G
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `c` char(1) character set latin1 default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.06 sec)

Suggested fix:
Should say CHARACTER SET in both places.