BullZip Home

When converting from an Access to MySQL database I got the following error.

- Error: -2147467259 (80004005) [MySQL][ODBC 5.1 Driver][mysqld-6.0.10-alpha-community]Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

Out of the three tables one of them failed which led to the above error.

Can anyone point me in the right direction to solve this issue?

I have temporarily resolved this issue by firstly creating a SQL dump file and then manually altering all of the varchar(255) data types to be text data types. The original data types in Access were set to be text with a limit of 255 characters so I do not see why this should give an error if the same limits are set in Access and MySQL?

I don't want all of the data types that I have manually altered to remain with such a high upper limit on characters but I also do not want to have to manually edit all of the SQL output from my Access databases as this would be very time consuming. Are there any answers or possible solutions to this?