On Tue, 14 Sep 2004, Sheraz wrote: > when I try following: > > CREATE TABLE `MyTable` ( > `SNumber` char(32) NOT NULL, > `UserID` char(32) NOT NULL default '0', > PRIMARY KEY (`SNumber`) > ) TYPE=MyISAM; > > It created the exactly correct table, But when i add > any varchar field in the above sql..then generated > table is like it has all the fields of type Varchar
This behaviour is documented (although slightly annoying) here: http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html cheers, Tobias -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
