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
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.x
• 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.