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

Reply via email to