>> Also I could be missing >> something, but I can't see the advantage in VARCHAR since space is not >> really a concern these days. > > char is fixed length and padded. If you don't fill up the space, the > db does it for you (even though it seems it's internal only). > > http://dev.mysql.com/doc/refman/5.0/en/char.html > > When CHAR values are stored, they are right-padded with spaces to the > specified length. When CHAR values are retrieved, trailing spaces are > removed. So where's the advantage of VARCHAR ? -- Richard Heyes HTML5 Graphing for FF, Chrome, Opera and Safari: http://www.rgraph.org (Updated January 4th) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
