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!