Web lists-archives.com

Re: longtext fields in a row




I thought that TEXT fields only stored a pointer to the actual data in the table,
not the data itself - storing 9 to 12 bytes in the table:

|"BLOB| <https://dev.mysql.com/doc/refman/5.0/en/blob.html>and|TEXT| <https://dev.mysql.com/doc/refman/5.0/en/blob.html>columns count from one to four plus eight bytes each toward the row-size limit because their contents are stored separately from the rest of the row."
  -- https://dev.mysql.com/doc/refman/5.0/en/column-count-limit.html

also: https://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

That said, I would think a better structure would be to have the data stored in a different
table, keyed to a table containing the date and integer fields...



On 4/1/15 10:35 AM, Andrew Mueller wrote:
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> 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