I'm upgrading to authoritative 3.4 and noticed that the records.content column
has been increased from 255 characters to 64000 characters. Because my table is
UTF-8, I get the following error:
mysql ALTER TABLE records MODIFY content VARCHAR(64000);
ERROR 1074 (42000): Column length too big for
DNSSEC and DKIM.
On Thursday, February 19, 2015, Nick Williams nicho...@nicholaswilliams.net
wrote:
I'm upgrading to authoritative 3.4 and noticed that the records.content
column has been increased from 255 characters to 64000 characters. Because
my table is UTF-8, I get the following error:
Hi Nick,
We use TEXT (utf-8) and have had no performance issues so far. My
understanding is that the innodb engine handles text efficiently - the
“content” data is stored inline in the general case, and only stored on a
separate page if it’s above a certain size for a given row.
Cheers,
Rob