I could be wrong (morning caffeine hasn't kicked in) but IIRC, you can't set a length on TEXT. You can only set a length on varchar, nvarchar, char, etc. If you try to set a length on a TEXT field, it tries to revert it to a varchar(?), which is limited.
That said, you can always programatically truncate things before you update/insert. --Ben Adkins, Randy wrote: > I am using MySQL and one of the tables I created has a COMMENTS > field (TEXT) and want to set the length of it to 4000. > > I am using the latest NaviCat 6.1 and I get the error that: > > 4000 is not a valid value for field 'Length'. The allowed range is 0 to > 255. > > Correct me if I am wrong, for TEXT data types, the max length can go > up to 65535 characters? > > Why would I get that type error for a TEXT field? > I also tried to set the data type to MEDIUMTEXT however with the same > error. > > Thanks > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:142189 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54