TEXT

[non_zero]

I'm having trouble with the TEXT type. I need to make a field with a maximum of 2500 characters, but every time I use the TEXT or BLOB type, it gives me a syntax error.

[dalida74]

u dont need to define the max length for this two types ( like the type long). u will get to enter a type maximum of 2500 characters.
maby this will help.
http://www.php.net/manual/en/language.types.php.

[industri]

No go =/

Don't set this in SQL.

Try setting the max input restraint either by JavaScript, PhP's string-length functions, or in clean HTML with the maxlength attribute.

Cheers.

[non_zero]

I don't need it for validation, just storage. Text and blob types are the only types that can store 2500 characters.

[non_zero]

Thanks. The documentation in phpMyAdmin failed to mention that.