On Sat, Jan 10, 2004 at 05:06:56PM +0500, Hassan Shaikh wrote: > It's really strange but when I execute the following statement, all my char(10) > columns turn into varchar(10). My other tables are ok and I've tried create dummy > table also. Problem seems to be associated with this table only. >
Your records don't have a fixed size because of a text column. I believe this triggers MySQL to use a variable size for each column, converting char to varchar. Functionally, it shouldn't make a difference I guess? Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
