Choosing Optimal Text Field

I'm trying to set up a group of fields that should probably hold no
more than 300-1000 characters max. However, I'm having a difficult
time choosing which field because for the varchar or char only go to
256 characters. After that, it seems like you go up over 10,000
characters and that is just no space efficient at all. Anyone have
suggestions? For each record I'll have like 10 of these text fields
and I'd hate to limit responses to 256 characters and would like them
to have between 400 and 1000 characters. Suggestions?

Marc wrote:

> I'm trying to set up a group of fields that should probably hold no
> more than 300-1000 characters max. However, I'm having a difficult
> time choosing which field because for the varchar or char only go to
> 256 characters. After that, it seems like you go up over 10,000
> characters and that is just no space efficient at all. Anyone have
> suggestions? For each record I'll have like 10 of these text fields
> and I'd hate to limit responses to 256 characters and would like them
> to have between 400 and 1000 characters. Suggestions?

Not a PHP question. For storage, it depends on your database - try a list
specific to your DB (or try type 'TEXT' or 'BLOB' instead of VARCHAR, or
store it outside the DB). You're also may run into problems with the
browser end.

HTH

C.