Cheers, (one and all),
On Sat, 16 Apr 2005, Dan Nelson wrote:
>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.
>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.