Why not just use VARCHAR()? They can be up to 65,535 characters in length in MySQL 5.0.3 and later.
http://dev.mysql.com/doc/refman/5.0/en/string-types.html ----- Original Message ----- From: "Will Tomlinson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, September 13, 2007 4:18 PM Subject: Re: Best data type for comments using MySQL? > >Med text allows for up to 65,535 characters so that should be plenty. >>Longtext allows for like millions. > > Fixed it! > > Thanks dude! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
