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

2020-10-30 Thread Michael Loftis via Pdns-users
On Fri, Oct 30, 2020 at 8:17 AM Michael Loftis wrote: > > On Fri, Oct 30, 2020 at 8:15 AM Nicholas Williams via Pdns-users > wrote: > > > > I thought domain names have supported unicode characters for several years > > now. > > Not at the protocol level they're not. They're punycode. And mor

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

2020-10-30 Thread Michael Loftis via Pdns-users
On Fri, Oct 30, 2020 at 8:15 AM Nicholas Williams via Pdns-users 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 wrote: > > Hi Nick, > > I gue

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

2020-10-30 Thread Michael Loftis via Pdns-users
I was hoping someone who knew more about PDNS authoritative server itself would chime in For MySQL server+client, if the character set in the libmysqlclient and server side tables/etc match, it doesn't matter except for server side sorts (collations). If it is latin1 all the way through then

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

2020-10-30 Thread Nicholas Williams via Pdns-users
I thought domain names have supported unicode characters for several years now. > On Oct 30, 2020, at 7:53 AM, Frank Louwers 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 de

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

2020-10-30 Thread Nicholas Williams via Pdns-users
Nobody has any thoughts here? Thanks, Nick > On Oct 25, 2020, at 11:51 AM, Nicholas Williams > 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 t