Not sure what I need for database

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!

thanks

Re: Not sure what I need for database

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!

It's really bad to multipost, if you ask the same question in more than one
newsgroup, then do a crosspost, this makes it easier for you to find the
replies to your question, people can see all the replies regardless which
newsgroup they are subscribing. You won't get multiple posts with the same
answer... the list can be done longer... now you have to find the right
newsgroup where you already got an answer to your question.