255 character limit

[SureFire]

I use phpmyadmin to create my tables. I have a field in a table that needs to contain more than 255 characters.

does anyone know how to create a field in php my admin that can hold more than this?

[cgraz]

try a text field. I believe it can hold something like 65535 characters.

Cgraz

[Norman_Graham]

The MySQL online manual contains detailed info on field and data types. The ones you want are:

CHAR
VARCHAR
TEXT
TINYTEXT
MEDIUMTEXT
LONGTEXT

Check it out: http://www.mysql.com/doc/en/String_types.html

Best o luck

Norm

[SureFire]

thanks guys! I got it now!