Updating MySql field from textarea 1

[melrse]

It looks like the max length of a field be it Varchar or char is 255. This means that when I update the field from textarea, I will only get the first 255 characters. Has anyone found a work around on this?

 

[sophisticate]

Use a different column type in your table definition. You can use BLOB or TEXT (they're interchangeable) to extend the character limit. You can prefix either of these to better define the max number of characters as follows:

TINY gets you 2^8
[no prefix] gets you 2^16
MEDIUM gets you 2^24
LONG gets you 2^32

Subtract 1 from any of the above and you have your limit.
So, TINYTEXT would result in a 255 character max.

Hope this helps,

brendanc@icehouse.net