In the last episode (Apr 16), Dan Bolser said: > The manual dosn't specify the maximum number of characters in the > > TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. > > http://dev.mysql.com/doc/mysql/en/blob.html
At the top of that page: The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT, correspond to the four BLOB types and have the same maximum lengths and storage requirements. There should probably be a link to http://dev.mysql.com/doc/mysql/en/string-type-overview.html , which gives you the exact limits. > Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? > > I have a field with just under 1000 characters, am I OK with a TINYTEXT? No, since TINYTEXT is limited to 256 bytes. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]