<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">I thought domain names have supported unicode characters for several years now.<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Oct 30, 2020, at 7:53 AM, Frank Louwers <<a href="mailto:frank@tembo.be" class="">frank@tembo.be</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta http-equiv="Content-Type" content="text/html; charset=utf-8" class=""><div style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Nick,<div class=""><br class=""></div><div class="">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.</div><div class=""><br class=""></div><div class="">Frank</div><div class=""><br class=""></div><div class=""><br class=""><div class=""><br class=""><blockquote type="cite" class=""><div class="">On 30 Oct 2020, at 13:43, Nicholas Williams via Pdns-users <<a href="mailto:pdns-users@mailman.powerdns.com" class="">pdns-users@mailman.powerdns.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="">Nobody has any thoughts here?<br class=""><br class="">Thanks,<br class=""><br class="">Nick<br class=""><br class=""><blockquote type="cite" class="">On Oct 25, 2020, at 11:51 AM, Nicholas Williams <<a href="mailto:nicholas@nicholaswilliams.net" class="">nicholas@nicholaswilliams.net</a>> wrote:<br class=""><br class="">In the past 4-5 years, I’ve gotten into the habit of defaulting all MySQL tables to this:<br class=""><br class=""> DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_520_ci<br class=""><br class="">Looking at the latest PowerDNS schema (I’m about to start up a second environment), I noticed that the entire schema has this:<br class=""><br class=""> CHARACTER SET ‘latin1'<br class=""><br class="">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?<br class=""><br class="">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?<br class=""><br class="">Thanks,<br class=""><br class="">Nick<br class=""></blockquote><br class="">_______________________________________________<br class="">Pdns-users mailing list<br class=""><a href="mailto:Pdns-users@mailman.powerdns.com" class="">Pdns-users@mailman.powerdns.com</a><br class=""><a href="https://mailman.powerdns.com/mailman/listinfo/pdns-users" class="">https://mailman.powerdns.com/mailman/listinfo/pdns-users</a><br class=""></div></div></blockquote></div><br class=""></div></div></div></blockquote></div><br class=""></body></html>