Any Substitute for varchar

Actually varchar supports only 256 character. i want a data type that will support more than 1000 characters. Is there any data type like varchar that supports my requirement.

TA
Raghu.

RTFM

text - 2^16-1 characters
mediumtext - 2^24-1 characters
longtext - 2^32-1 characters

These datatypes cannot be indexed.

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by rod k:
RTFM

text - 2^16-1 characters
mediumtext - 2^24-1 characters
longtext - 2^32-1 characters

These datatypes cannot be indexed.[/quote]

I've tried with text in create table. Its not working.

My create table is:
create table table_name(col_name text(1000));
gives an error:
parse error near '(1000))' at line 1

Raghu.

Did you RTFM?

You can't set the size of a text datatype.