VARCHAR is limited to 256 characters. TEXT is much longer, like 6000 or
60000 characters or so, don't actually know. I believe both TEXT and
varchar both support full text searches. You can store HTML in the
database, just be sure to addslashes and stripslashes going in and out.
Your server may be set to do both automatically if you are using PHP.
Find out for sure, lest you end up with two sets of slashes on
everything that has a quote or an apostrophe in it. If you can, try to
get away with as little formatting in the database as possible, and
have your page templates create the necessary HTML. It's much easier to
edit it later that way.
Walter
sql
---------------------------------------------------------------------
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
