From: Kevin Campbell <[EMAIL PROTECTED]> > What's the best data type to use for storing guest book comments in my > database table.
The "best" data type would be the kevins_gb_comment data type, but I don't think that's implimented in MySQL yet. If all you are doing is storing and retrieving the data, then you'll probably want to use the text() type. If you will also want to do some searching, then you might want to use a text() column to hold the display data and set up a few processed varchars() to hold interesting strings to match searches against. But the whole searching thing can become a pretty big subject. --- Rodney Broom Programmer: Desert.Net Spam filter: sql database --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php