Create Table

[Cassiano Prado Oliveira]

Why when i create a table like this:
CREATE TABLE `prmsnctabelas2` (
  `cdempresa` varchar(5) NOT NULL DEFAULT '',
  `cdfilial` CHAR(2) NOT NULL DEFAULT '',
  `nometabela` char(50) NOT NULL DEFAULT '',
  PRIMARY KEY  (`cdempresa`,`cdfilial`,`nometabela`)
) TYPE=MyISAM CHARSET=latin1
 
the result is:
CREATE TABLE `prmsnctabelas3` (
  `cdempresa` varchar(5) NOT NULL DEFAULT '',
  `cdfilial` CHAR(2) NOT NULL DEFAULT '',
  `nometabela` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY  (`cdempresa`,`cdfilial`,`nometabela`)
) TYPE=MyISAM CHARSET=latin1
 
Why the type of field nometabela was changed to varchar???
Just 'cause the structure has a field with this type?


---------------------------------
Yahoo! GeoCities: a maneira mais fácil de criar seu web site grátis!