[Pdns-users] Why was content length increased?

[Michael Loftis]

DNSSEC and DKIM.

On Thursday, February 19, 2015, Nick Williams <nicholas at 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:
>
> mysql> ALTER TABLE records MODIFY content VARCHAR(64000);
> ERROR 1074 (42000): Column length too big for column 'content' (max =
> 21845); use BLOB or TEXT instead
>
> I know I can use latin1, but I tend to avoid any non-Unicode character
> sets completely, and would prefer to stick with UTF-8. Given that:
>
> - What changed that required the increase from 255 to 64,000 characters?
> - Is there any reason that I couldn't just use VARCHAR(21845)?
> - Are there any performance implications to using TEXT instead of
> VARCHAR(64000)?
>
> Thanks,
>
> Nick
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com <javascript:;>
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
>


-- 

"Genius might be described as a supreme capacity for getting its possessors
into trouble of all kinds."
-- Samuel Butler
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20150219/817031e9/attachment-0001.html>