I believe in newer versions of MySQL, there is only varchar and it can range from 1 to the max length which I believe is 65534. LargeText is for 65535 up to around 10 or 15 million characters.
-----Original Message----- From: Richard White [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 9:56 AM To: CF-Talk Subject: Max Varchar Length HI, Just wondering if anyone works with mysql and can help us understand this little issue. we understood that the maximum length for a varchar is 255. however we read somewhere that since mysql version 5.0.3 the varchar maximum length is 767. We have just been testing this theory and dont know why but the database is allowing us to alter a columns data type to varchar(50000), if we set it to varchar(65535) it tells us it is too big and that we need to include a text data type instead. This is of course what we expected but we expected this error to occur way before we was allowed to insert varchar(50000) and would have expected it on either varchar(256) or varchar(768) depending on the version we have Hope this makes sense and would really appreciate any help with understanding this and how to best use the text and varchar data types thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291959 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
