Re: longtext fields in a row

All, Unfortunatelu this didn't do the trick. I changed (with PHPMYADMIN) all fields from LONGTEXT to TEXT, all other parameters furthermore unchanged. Ran the same procedure again, but stopped updating the row at exact the same spot. How come? No idea. What I'm trying to achiev is this: I

Re: longtext fields in a row

Hi Andrew, On 4/1/2015 1:58 PM, Andrew Wallace wrote: 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| and|TEXT|

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| and|TEXT| columns count from one to four plus

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 placin

Re: longtext fields in a row

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 wrote: > Hello, > > I'm fiddling wit a table where I put in a date field (datetime, also

longtext fields in a row

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: 12.925.965