I don't think you specifiy the Length for a text field. It gets as big as it needs to in blocks of (8K?).
Jerry Johnson Web Developer Dolan Media Company >>> [EMAIL PROTECTED] 01/12/05 10:14AM >>> 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:142190 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