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.
>>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
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.