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:142188 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=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
