At 20:43 -0600 2/26/03, Paul DuBois wrote:
At 21:32 -0500 2/26/03, Jianping Zhu wrote:
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet maybe very long, is
there a better way to handle it instead of set a varchar(2000) or more for
a field comment in the table?
VARCHAR has a maximum length of 2000. In MySQL 4.1, it will be converted
automatically to TEXT. But you can use TEXT in any version of MySQL.
Is that suitable for what you want?
Replying to myself here. Sometimes it's best to engage the brain before
replying:
VARCHAR has a maximum length of *255*, not 2000. If you declare a
VARCHAR with a longer length, it is converted to an appropriate TEXT
type in MySQL 4.1. Prior to 4.1, you get an error.
---------------------------------------------------------------------
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
