On Tue, 2009-01-06 at 11:01 +1100, Ross McKay wrote: > Micah Gersten wrote: > > >You're referencing the 5.1 manual. In the 5.0 manual it says that > >VARCHAR was extended to 65535 in 5.0.3, so you're statement is not > >entirely correct, nor was Stuart's. That's why I linked him to the 5.0 > >manual page on data types. > > Good point, thanks! I usually read from the .chm manual but just jumped > to the website to grab a link. Should have been: > > http://dev.mysql.com/doc/refman/5.0/en/string-types.html > > I note that Stuart was most likely talking about MySQL <= 4 which had a > limit of 255 characters for varchar.
I guess it's time for me to re-read the complete up-to-date manual too... "You can have indexes on BLOB and TEXT columns only as of MySQL 3.23.2 for MyISAM tables or MySQL 4.0.14 for InnoDB tables. Previous versions of MySQL did not support indexing these data types." :) Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
