At 23:10 -0500 2/26/03, Jianping Zhu wrote:
>Thanks for response.
>what will happen if commnet size is more that 2000?
Use whichever one of the TEXT column types can hold as much as you
want to allow as your maximum comment size. The MySQL manual indicates
the maximum length for TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT.
>
>J.P.
>
>On Wed, 26 Feb 2003, 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?
>>
>>
>> >
>> >Thanks
>>
>
>
>--------------------------------
>Jianping Zhu
>Department of Computer Science
>Univerity of Georgia
>Athens, GA 30602
>Tel 706 5423900
>--------------------------------
