Hi
I'm using Mysql 4.x...
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
i mean it converest SNumber , and UserID to varchar
too...
following is the example , On execution of follwoing
the generated table's all the field will be varchar
despite char.....
CREATE TABLE `categories` (
`SerialNumber` char(32) NOT NULL,
`UserID` char(32) NOT NULL default '0',
`Description` varchar(45) NOT NULL default '',
PRIMARY KEY (`SerialNumber`)
) TYPE=MyISAM;
What is this behaviour can any one explain me ?..or
Wht should i do if i need char and varcha fields in my
schema ...?
Thanks
Sheraz
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
