http://www.mysql.com/doc/n/o/node_357.html
explains the different string data types and the storage requirements: Column Type Storage required [...] VARCHAR(M) L+1 bytes, where L <= M and 1 <= M <= 255 [...] TINYBLOB, TINYTEXT L+1 bytes, where L < 2^8 [...] These two storage requirements are exactly the same, so isn't a TINYBLOB almost exactly like a VARCHAR(255) BINARY, and a TINYTEXT almost exactly like a VARCHAR(255)? There are some differences listed at: http://www.mysql.com/doc/B/L/BLOB.html Apparently, in MySQL 3.23.2, the only difference between a TINYTEXT and a VARCHAR(255) is that TEXT/BLOB fields can't have default values and trailing spaces are not removed as they are in VARCHAR values. But are those really the only differences? -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 --------------------------------------------------------------------- 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
