The only time you will gain a speed advantage is if you have no variable >>length fields in your record (varchar, text, etc.). You may notice that >>all your CHAR fields are changed to VARCHAR as soon as a variable length >>field type is added. CHAR is less efficient from a space storage point >> >>
On that note, I've often wanted to be able to do something along the lines of: ALTER TABLE foo USE CHAR; ALTER TABLE foo USE VARCHAR; ... and just port the current max-length values between the two, while changing all relevant columns. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock ... sql --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php