On Thu, Jan 16, 2003 at 06:47:03PM +0100, Stefan Hinz wrote: > Keith, > > thanks once again! Well, anyone here from the MySQL developer team? Or > any other guru who can explain why 10 = 11?
Hi Stefan, Here is my guess. ;) CHAR columns are fixed width. A CHAR column with a width of 10 will always require 10 bytes - regardless of what is put into it. If the column also allows NULL values, then the length of all columns becomes 10 bytes + 1 byte for the NULL. Cheers! -- Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate | http://zak.fooassociates.com Developing Dynamic Web Applications with MySQL and PHP MySQL Training: Nuernburg, June 02-06, 2003 Visit http://mysql.com/training for more information "Gosh, Batman. The nobility of the almost-human porpoise." --Robin, the Boy Wonder --------------------------------------------------------------------- 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