Posted by J.O. Aho on 01/26/06 14:17

jack wrote:
> Hi,
>
> I'm starting a classified ad web site and I've been wrestling with varchar
> 255 in my database for holding item descriptions but I notice on long
> descriptions it doesn't carry over all the text. So I'm left with TEXT or
> BLOB which after experimenting works but I'm not sure of any disadvantages
> with either.
> Can I get some feedback as what is recommended for something like this? I've
> read the MySQL site regarding these two fields but it went way over my head!

If I remember it right, BLOB can be what ever while TEXT is supposed to be
characters that are included in the charactersetup used for the database.


//Aho

[Back to original message]