Thanks, I removed the field and re-created it with TEXT and did not specify a Length. I will take care of that on the action page.
Much appreciated -----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 12, 2005 10:20 AM To: CF-Community Subject: Re: MySQL Question 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 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:142191 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
