I'm having the same problem. I did a performance test, and CHAR columns are significantly faster than VARCHAR (at least on my platform - MySQL 4.1.1a on Win32). I setup a webpage with my sample code (VB) so that you can run the test yourself:
http://au.geocities.com/m_fagan/VARCHARvsCHAR.html The results were that table join on CHAR-CHAR was about 15% faster than join on VARCHAR-VARCHAR. Does anyone know how to stop the auto-conversion of CHAR to VARCHAR ? ----- Original Message ----- From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 10, 2004 7:06 AM Subject: Automatic conversion from `char` TO `varchar` > Hi, > > 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. ... Matt Fagan http://greetings.yahoo.com.au - Yahoo! Greetings Send your love online with Yahoo! Greetings - FREE! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
