Re: Character sets and migration from 4.0 to 4.1

[Andrew Blee]

This is definitely a problem related to InnoDB tables.

I can create 1 INDEX field (usually called unique_id of type INT/UNIQUE) and 11 TEXT fields and put "some" data in without any problems.

It is only when I put in lots of data to the TEXT fields does this problem occur. I.e. a TEXT field can hold 32000 characters, if I fill the first 10 fields with 32000 characters each it works. Only when I start putting some characters inside the 11th TEXT field will it at some point fail. I am sure I could create 20 TEXT fields without any problems, and problems would only occur when I reach the limit somewhere between 320000 characters and 352000 characters.

So is this a problem of too much data inside the fields OR the fact the INDEX created relates to the TEXT fields as well as the unique_id field I set it for?