Re: Row size limit
Posted by:
Rick James
Date: August 26, 2010 08:34PM
Are you really using names like `column31`? If so, you should really move these fields to another table (with up to 31 times as many rows). It would contain
id -- for joining to main table
TINYINT -- 1..31 for column1..column31
VARCHAR(255)
Perhaps something less than 255 would be reasonable for some of the fields?
TEXT and BLOB are stored somewhere else (after the first 768 bytes). So, a table with VARCHAR(65535) will fail, but with TEXT will work.
Subject
Written By
Posted
Re: Row size limit
August 26, 2010 08:34PM
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.