why cant i set varchar to be 1000 in length
mysql
Solution
Depends what version of MySQL you are running, before 5.0.3 there was a 255 character limit for varchar:
Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions.
From: http://dev.mysql.com/doc/refman/5.0/en/char.html
Problem
if this matters, i also set it unique The max I've managed to set for varchar is 745 (it's set to unique also).