[Pdns-users] gmysql: Is latin1 really necessary? What are the consequences of using UTF-8?

[Michael Loftis]

On Fri, Oct 30, 2020 at 8:15 AM Nicholas Williams via Pdns-users
<pdns-users at mailman.powerdns.com> wrote:
>
> I thought domain names have supported unicode characters for several years now.

Not at the protocol level they're not.   They're punycode.


>
> On Oct 30, 2020, at 7:53 AM, Frank Louwers <frank at tembo.be> wrote:
>
> Hi Nick,
>
> I guess the main reason why it's latin1, is that DNS records are supposed to be ascii, certainly not utf-8. Also probably the "lowest common denominator" between various (My)SQL versions, flavours etc.
>
> Frank
>
>
>
> On 30 Oct 2020, at 13:43, Nicholas Williams via Pdns-users <pdns-users at mailman.powerdns.com> wrote:
>
> Nobody has any thoughts here?
>
> Thanks,
>
> Nick
>
> On Oct 25, 2020, at 11:51 AM, Nicholas Williams <nicholas at nicholaswilliams.net> wrote:
>
> In the past 4-5 years, I’ve gotten into the habit of defaulting all MySQL tables to this:
>
>   DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_520_ci
>
> Looking at the latest PowerDNS schema (I’m about to start up a second environment), I noticed that the entire schema has this:
>
>   CHARACTER SET ‘latin1'
>
> I did some searching through the archives, but couldn’t readily find an answer about this: Is there a specific reason why LATIN-1 was chosen and must be used? What are the consequences of using UTF-8 instead of LATIN-1?
>
> One consequence that I know of is that `records.content` can’t be VARCHAR(64000) and also be UTF-8, so it must either be made explicitly LATIN-1, or it must be shortened to VARCHAR(16383), or it must be converted to a TEXT column. Are there are negative consequences of making it a TEXT column?
>
> Thanks,
>
> Nick
>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>
>
>
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> https://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