Max Varchar Length Bug

[tobydoig]

Using sqlyog ent 5.01 WinXP i try to alter a table running on mysql 5.0.16 on debian linux, to increase the size of a varchar field from 255 to 2048 and sqlyog says the max length if 255. according to the mysql docs, as of mysql 5.0.3 the max varchar length is 65335.

http://dev.mysql.com/doc/refman/5.0/en/char.html

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 maximum effective length of a VARCHAR in MySQL 5.0.3 and later is determined by the maximum row size and the character set used. The maximum length overall is 65,532 bytes.)

not a major issue, but would be nice to sort this at some point. it just tripped me up.

[Ritesh]

This is very strange. It seems to be a error returned from MySQL itself.

Can you check the HISTORY tab which should contain the ALTER/CREATE table statement that SQLyog generates? Do you find anything wrong in that?

[peterlaursen]

I have a MySQL 5.0.16 running on SuSE Linux 10.

When I connect to this MySQl from another machine running WinXP/SQLyog I can easily ALTER TABLE to varchar size greater than 255 (the upper limit before MySQL 5).

i think it is an issue with your MYSQL installation on LINUX. Did you update from a previous MySQl version? Did you then run the update scripts after updating.

I think you should try to dump your data, remove MySQL on LINUX (including deleting the /datadir), and then reinstall and import data.

I don't know the .deb install packages. it could be a problem here when upgrading. There is no such problems with the .rpm install packages used by RH/FC/SuSE.

[Author]

Posts