At 17:27 +0000 1/21/03, Craig melia wrote:
Hi
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
too much.
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?
Craig
---------------------------------------------------------------------
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
