topic-24599

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

MySQL - problem while inserting
Posted: Tue Aug 07, 2012 01:26 PM

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

Posts: 368

Joined: Sun May 31, 2009 06:25 PM

Re: MySQL - problem while inserting
Posted: Tue Aug 07, 2012 01:48 PM

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

Regards,

André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: MySQL - problem while inserting
Posted: Tue Aug 07, 2012 02:43 PM

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

Posts: 368

Joined: Sun May 31, 2009 06:25 PM

Re: MySQL - problem while inserting
Posted: Tue Aug 07, 2012 03:30 PM

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.

Regards,

André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10

Marc Vanzegbroeck

Posts: 1195

Joined: Mon Oct 17, 2005 05:41 AM

Re: MySQL - problem while inserting
Posted: Tue Aug 07, 2012 03:42 PM

ADutheil wrote: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

FiveTech Support Forums

Continue the discussion