At 17:27 +0000 1/21/03, Craig melia wrote:
>I am building my 1st app in php with Mysql and I hope you can help.
>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
Why does this matter? MySQL doesn't store 65535 characters per value,
just the characters that are actually in your string. The column uses
only as much space as is necessary.
You can easily enforce a limit of 650 characters in your application.
>Is there anything I can do to set a column type to recieve just 650
>characters of text, or something similar?