On 21 Jan 2003, at 17:27, Craig melia wrote: > I want to have users give a description in a form and varchar(255) > wont give me enough space so I thought I would use text(650) but it > seems the 'text' type wont take the limit of (650), it simply offers > the user (65535): way too much.
Use a TEXT column and limit the length of the input in your application, which you probably should be doing anyway (since just having MySQL truncate it without notifying the user wouldn't be very friendly). [Filter fodder: SQL] -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 --------------------------------------------------------------------- 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