SQL 2005 Varchar(MAX)
Regards Dale Fraser http://learncf.com -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 October 2007 12:35 AM To: CF-Talk Subject: RE: Max Varchar Length 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
