Thanks for response. what will happen if commnet size is more that 2000? 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 -------------------------------- --------------------------------------------------------------------- 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