Re: longtext fields in a row
- Date: Wed, 01 Apr 2015 19:37:54 +0200
- From: Trianon 33 <trianon33@xxxxxxxxx>
- Subject: Re: longtext fields in a row
Ok, thanks, couldn't find that anywhere.
Need to think for a different solution......
Anyway thanks for the remark, best regards, Schimanski.
Andrew Mueller schreef op 01-04-15 om 19:35:
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 <trianon33@xxxxxxxxx
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
Is there a max of longtext fields in 1 row?
Is there a max of longtext size in 1 row?
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>