MySQL Forums
Forum List  »  InnoDB

Re: Character sets and migration from 4.0 to 4.1
Posted by: Andrew Blee
Date: April 29, 2005 04:25AM

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?

Options: ReplyQuote

Written By
Re: Character sets and migration from 4.0 to 4.1
April 29, 2005 04:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.