There is a max row size of 65,535 bytes. There is no real way to get around this limit other than placing the HTML code somewhere else, perhaps in a different table.
On Wednesday, April 1, 2015, Trianon 33 <triano...@gmail.com> wrote: > Hello, > > I'm fiddling wit a table where I put in a date field (datetime, also key) > and some integer fields (8 of them mostly 14 long) and some longtext fields > (16 of them). > > The longtext fields are filled with some statistics I generate complete > with HTML around, something like this: <td>12.925.965</td> but than bigger, > but mostly smaller than 1 Mb. > > This row is initially created by filling the first 10 fields (datetime, > the integer and the 1st longtext) and than updated each and every time the > next longtext value available is. > > However this is ok up to the 10th longtext field and than it stops. The > next longtext operations runs ok, no errormessages etc. but the longtext > field itself remains empty. > > Up to now I have no clue about my wrongdoings, so do you have any > suggestions? > > Is there a max of longtext fields in 1 row? > Is there a max of longtext size in 1 row? > > Other idea's? > > Thanks in advance for any advice, best regards, Schimanski. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > -- </Andrew R. Mueller> </603-748-8449>
