MySQL - problem while inserting

[Marc Vanzegbroeck]

Hi,

I have a strange error while updating fields in a MySQL-table.

I the message:
Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. You have to change some columns to TEXT or BLOBs

The command I use is
UPDATE instel SET FACT_TOTA3='Total' WHERE ID = 15

The command is working everywhere very nice, only in one table with 169 fields it is not working if I want to update from field 151.

What can be the problem?

Thanks
Marc

[ADutheil]

Seems that the total width of the sum of your fields is larger than 8126 wich is the maximum allowed for a line.

[Marc Vanzegbroeck]

Thanks,

I didn't know there was a limitation mer line in MySQL. Till now I was using SQLite, and there was no limitation there.
It seems I have to split the table in 2 ...

Marc

[ADutheil]

If you have large CHAR fields you might want to change tem to TEXT or BLOB because they are not accounted to the max line size.

[Marc Vanzegbroeck]

If you have large CHAR fields you might want to change tem to TEXT or BLOB because they are not accounted to the max line size.

Thanks, I will try that.

Regards,
Marc