Quote:
Originally Posted by fhomess
... Depending on your version of MySQL, you may need to change the type of the field to something that can handle larger character limits, but it won't affect the functionality of StatsLab to change the field type, either.
|
Thanks again, done and it worked perfectly. The version of MySQL was key as you say. From
MySQL :: MySQL 5.0 Reference Manual :: 10.4.1 The CHAR and VARCHAR Types ....
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. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.