Posted by Tom on 02/21/07 18:29

On Wed, 21 Feb 2007 15:51:07 +0100, J.O. Aho wrote...
>
>akuza wrote:
>> hi
>>
>> which one is the best for use for performance and storage -
>> MEDIUMBLOB or MEDIUMTEXT?
>
>Depends on what you want to store, just standard text, then go with TEXT, but
>if you want to store images, binaries then go with BLOB.
>

If the information being added to the database is predictable, you might also
consider using a varchar() setting if the length is always under 255.

Tom
--
Newsguy.com
75+ days of Binary and Text Retention!
Higher levels of article completion!
Broader coverage of newsgroups

[Back to original message]