I thought domain names have supported unicode characters for several years now.
> 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 <mailto: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 <mailto: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 <mailto: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
