Bug #208 SHOW CREATE TABLE tablename incomplete
Submitted: 28 Mar 2003 13:51 Modified: 29 Mar 2003 7:36
Reporter: Benoit St-Jean Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.4-beta-max-nt OS:Microsoft Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[28 Mar 2003 13:51] Benoit St-Jean
Description:
When creating a table with a column type of NATIONAL VARCHAR(xx), the command SHOW CREATE TABLE tablename doesn't show "NATIONAL" in the create table.

This problem can also be reproduced with other MySQL clients (e.g. SQLyog 2.5).

Problem can be reproduced for InnoDb, MyISAM and HEAP.  Didn't try it with DBD though.

How to repeat:
CREATE TABLE abc (column1 NATIONAL VARCHAR(10)) TYPE=MyISAM;
SHOW CREATE TABLE abc;

Suggested fix:
?
[29 Mar 2003 7:36] Indrek Siitan
MySQL currently doesn't support the NATIONAL. Or actually, it does - it doesn't support anything else, so the NATIONAL is dropped. It's just supported in CREATE TABLE for compatibility reasons to help porting data from other databases.