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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291956 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
