On Fri, Oct 30, 2020 at 8:15 AM Nicholas Williams via Pdns-users <pdns-users@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 <fr...@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@mailman.powerdns.com> wrote: > > Nobody has any thoughts here? > > Thanks, > > Nick > > On Oct 25, 2020, at 11:51 AM, Nicholas Williams > <nicho...@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@mailman.powerdns.com > https://mailman.powerdns.com/mailman/listinfo/pdns-users > > > > _______________________________________________ > Pdns-users mailing list > Pdns-users@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 _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
