[Pdns-users] Why was content length increased?
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@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Why was content length increased?
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: 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@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 ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] Why was content length increased?
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 On Feb 20, 2015, at 5:12 AM, 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: 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@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users