<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi Denis, Colleagues,<div class=""><br class=""></div><div class="">As you requested, the Database team will prepare a thorough investigation (impact analysis) of UTF-8 in the RIPE Database, as a starting point for further discussion.</div><div class=""><br class=""></div><div class="">Regards</div><div class="">Ed Shryane</div><div class="">RIPE NCC</div><div class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 5 Aug 2020, at 14:46, <a href="mailto:ripedenis@yahoo.co.uk" class="">ripedenis@yahoo.co.uk</a> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class=""><div class="ydp3e4dece1yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div class=""></div> <div dir="ltr" data-setdir="false" class="">Colleagues</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">We have a problem with UTF-8. Many people keep saying you want it, we should have it, lets do it...But every time we get to these difficult, non technical questions every one goes silent. This is why we have never implemented UTF-8 since it was first mentioned many years ago. No one in the community seems to know how to answer these questions.</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">So I have a suggestion. The RIPE NCC has the manpower with the expertise to investigate these issues. I propose we put a task on the RIPE NCC to do a thorough investigation of UTF-8 in the RIPE Database from all possible angles and report back to the community. This can be a starting point to a more meaningful discussion.</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">We need to know what impact having non Latin1 characters in different parts of the data set will have on the RIPE Registry, the RIPE NCC members, the different user groups of the RIPE Database and the social, legal and political impact of such a change. Which parts of the data set can/should/shouldn't be allowed to be in other character sets. Who really needs access to this data and what parts of it need to be understandable or interpreted. Which does bring into question the whole purpose of the RIPE Database and the data contained therein.</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">Thoughts???</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">cheers</div><div dir="ltr" data-setdir="false" class="">denis</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class="">co-chair DB-WG</div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div dir="ltr" data-setdir="false" class=""><br class=""></div><div class=""><br class=""></div> </div><div id="ydpa6163e49yahoo_quoted_7611391812" class="ydpa6163e49yahoo_quoted"> <div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;" class=""> <div class=""> On Friday, 31 July 2020, 20:20:10 CEST, Leo Vegoda <<a href="mailto:leo@vegoda.org" class="">leo@vegoda.org</a>> wrote: </div> <div class=""><br class=""></div> <div class=""><br class=""></div> <div class=""><div dir="ltr" class="">Hi Denis,<br clear="none" class=""><br clear="none" class="">These are good questions. As so many of the answers lie with the RIPE<br clear="none" class="">NCC or the NRO, I suppose we need input from them to proceed further.<br clear="none" class=""><br clear="none" class="">Kind regards,<br clear="none" class=""><br clear="none" class="">Leo<br clear="none" class=""><div class="ydpa6163e49yqt4775871487" id="ydpa6163e49yqtfd07922"><br clear="none" class="">On Wed, Jul 29, 2020 at 3:47 PM <a shape="rect" href="mailto:ripedenis@yahoo.co.uk" rel="nofollow" target="_blank" class="">ripedenis@yahoo.co.uk</a><br clear="none" class=""><<a shape="rect" href="mailto:ripedenis@yahoo.co.uk" rel="nofollow" target="_blank" class="">ripedenis@yahoo.co.uk</a>> wrote:<br clear="none" class="">><br clear="none" class="">> Hi Leo<br clear="none" class="">><br clear="none" class="">> Some of the questions that need to be answered include:<br clear="none" class="">><br clear="none" class="">> -who needs to be able to read/understand/interpret which parts of the data in the RIPE Database (maybe both the community and the NCC need input to answer this)?<br clear="none" class="">> -is any of the data contained in the RIPE Database essential for the operation of the registry and not duplicated anywhere else (maybe the NCC and the NCC Services WG need input to answer this)?<br clear="none" class="">> -is any of the data important to LEAs and governments, is that a consideration, do they have the resources to understand the data in any format (community and LEAs input needed for this one)?<br clear="none" class="">> -One of the mission statements of the NRO is "Providing and promoting a coordinated Internet number registry system" so if we are going to internationalise the public face of the registry should it be coordinated(is that a community, RIR or NRO question)?<br clear="none" class="">><br clear="none" class="">> cheers<br clear="none" class="">> denis<br clear="none" class="">><br clear="none" class="">> co-chair DB-WG<br clear="none" class="">><br clear="none" class="">> On Wednesday, 29 July 2020, 21:09:55 CEST, Leo Vegoda <<a shape="rect" href="mailto:leo@vegoda.org" rel="nofollow" target="_blank" class="">leo@vegoda.org</a>> wrote:<br clear="none" class="">><br clear="none" class="">><br clear="none" class="">> Hi Denis,<br clear="none" class="">><br clear="none" class="">> I agree that this is a registry issue and not just a database issue,<br clear="none" class="">> which is why I sent the message I did on 8 July.<br clear="none" class="">><br clear="none" class="">> I'd like to understand how much of this work should be led by the RIPE<br clear="none" class="">> NCC versus the community. Also, because of the breadth of the issues,<br clear="none" class="">> should the discussion be here or on another list?<br clear="none" class="">><br clear="none" class="">> Kind regards,<br clear="none" class="">><br clear="none" class="">> Leo Vegoda<br clear="none" class="">><br clear="none" class="">> On Wed, Jul 29, 2020 at 10:45 AM <a shape="rect" href="mailto:ripedenis@yahoo.co.uk" rel="nofollow" target="_blank" class="">ripedenis@yahoo.co.uk</a><br clear="none" class="">> <<a shape="rect" href="mailto:ripedenis@yahoo.co.uk" rel="nofollow" target="_blank" class="">ripedenis@yahoo.co.uk</a>> wrote:<br clear="none" class="">> ><br clear="none" class="">> > Hi Leo<br clear="none" class="">> ><br clear="none" class="">> > As I have said many times, internationalising the RIPE Database is not a technical issue, it is a registry issue. I think it does need a separate process from the database requirements. Especially if we consider it as a cross registry issue.<br clear="none" class="">> ><br clear="none" class="">> > Incidentally I did suggest on this mailing list several months ago that the requirements task force considers the issue of UTF-8. No one from the task force has yet replied to me on that or any other comment I have made about the requirements.<br clear="none" class="">> ><br clear="none" class="">> > cheers<br clear="none" class="">> > denis<br clear="none" class="">> ><br clear="none" class="">> > co-chair DB-WG<br clear="none" class="">> ><br clear="none" class="">> > On Wednesday, 29 July 2020, 18:20:14 CEST, Leo Vegoda <<a shape="rect" href="mailto:leo@vegoda.org" rel="nofollow" target="_blank" class="">leo@vegoda.org</a>> wrote:<br clear="none" class="">> ><br clear="none" class="">> ><br clear="none" class="">> > Hi,<br clear="none" class="">> ><br clear="none" class="">> > Thanks for providing the impact analysis for this initial change.<br clear="none" class="">> ><br clear="none" class="">> > What should the process be for introducing greater support for<br clear="none" class="">> > internationalization in the RIPE Database? George, Cynthia and others<br clear="none" class="">> > have made good points about the need to improve internationalization<br clear="none" class="">> > of more than just e-mail addresses. Is that support something that<br clear="none" class="">> > should be handled through the process that follows the final report of<br clear="none" class="">> > the Database TF or does it need to be addressed separately?<br clear="none" class="">> ><br clear="none" class="">> > Thanks,<br clear="none" class="">> ><br clear="none" class="">> > Leo<br clear="none" class="">> ><br clear="none" class="">> > On Wed, Jul 29, 2020 at 8:03 AM Edward Shryane via db-wg <<a shape="rect" href="mailto:db-wg@ripe.net" rel="nofollow" target="_blank" class="">db-wg@ripe.net</a>> wrote:<br clear="none" class="">> > ><br clear="none" class="">> > > Dear Colleagues,<br clear="none" class="">> > ><br clear="none" class="">> > > Here is the impact analysis for the NWI-11 implementation.<br clear="none" class="">> > ><br clear="none" class="">> > > The Database team plans to implement NWI-11 as per the Solution Definition:<br clear="none" class="">> > > <a shape="rect" href="https://www.ripe.net/ripe/mail/archives/db-wg/2020-June/006525.html" rel="nofollow" target="_blank" class="">https://www.ripe.net/ripe/mail/archives/db-wg/2020-June/006525.html</a><br clear="none" class="">> > ><br clear="none" class="">> > > (1) Impact to Whois Update<br clear="none" class="">> > ><br clear="none" class="">> > > The implementation will automatically apply Punycode encoding (as per RFC 5891) to the domain part of an email address during Whois update.<br clear="none" class="">> > ><br clear="none" class="">> > > The encoding is only applied to an IDN domain name, and changes the current behaviour as follows:<br clear="none" class="">> > > - ASCII encoded values will not be affected (as before).<br clear="none" class="">> > > - Non-ASCII but latin-1 encoded values will be encoded as Punycode.<br clear="none" class="">> > > - Non-latin-1 encoded values (e.g. UTF-8) will also be encoded as Punycode. These values previously were transformed to latin-1, with a '?' substitution.<br clear="none" class="">> > ><br clear="none" class="">> > > The local part of an email address must only contain ASCII characters. If non-ASCII characters are found in the local part, the address is rejected as invalid.<br clear="none" class="">> > ><br clear="none" class="">> > > This change will only affect attributes with an email address syntax (i.e. abuse-mailbox, e-mail, irt-nfy, mnt-nfy, notify, ref-nfy, upd-to).<br clear="none" class="">> > ><br clear="none" class="">> > > If an email address is converted to Punycode, a warning will be included in the update response.<br clear="none" class="">> > ><br clear="none" class="">> > > Any Punycode conversion failure will result in the attribute value being rejected as invalid. A workaround in this case is to encode the value before submitting the update.<br clear="none" class="">> > ><br clear="none" class="">> > > (2) Impact to Whois Query<br clear="none" class="">> > ><br clear="none" class="">> > > When querying the RIPE database, any Punycode encoded email address is returned as-is (i.e it is not decoded).<br clear="none" class="">> > ><br clear="none" class="">> > > (3) Impact to Existing Data<br clear="none" class="">> > ><br clear="none" class="">> > > We will perform a cleanup to convert any existing non-ASCII (but latin-1 encoded) IDN domain names to Punycode in attributes with an email address syntax. This affects very few objects. The maintainer(s) will be notified by email beforehand.<br clear="none" class="">> > ><br clear="none" class="">> > > (4) Impact to Whois Documentation<br clear="none" class="">> > ><br clear="none" class="">> > > We will update the database documentation with details of this behaviour change.<br clear="none" class="">> > ><br clear="none" class="">> > > (5) Release Timeline<br clear="none" class="">> > ><br clear="none" class="">> > > We expect the NWI-11 implementation to take about 1 month (including code changes and testing), and will include the feature in the Whois 1.98 release.<br clear="none" class="">> > ><br clear="none" class="">> > > As usual, we will deploy the release to the Release Candidate environment for 2 weeks before production, to allow for testing.<br clear="none" class="">> > ><br clear="none" class="">> > > Regards<br clear="none" class="">> > > Ed Shryane<br clear="none" class="">> > > RIPE NCC<br clear="none" class="">> > ><br clear="none" class="">> > ><br clear="none" class="">> > ><br clear="none" class="">> > > On 23 Jul 2020, at 12:00, <a shape="rect" href="mailto:ripedenis@yahoo.co.uk" rel="nofollow" target="_blank" class="">ripedenis@yahoo.co.uk</a> wrote:<br clear="none" class="">> > ><br clear="none" class="">> > > Hi Ed<br clear="none" class="">> > ><br clear="none" class="">> > > The chairs see there is a consensus to move forward with implementing Punycode. Can you present an impact analysis explaining what changes you propose, what effect those changes will have on updates and queries (by all the different methods), if anyone needs to modify their software interacting with the database.<br clear="none" class="">> > ><br clear="none" class="">> > > cheers<br clear="none" class="">> > > denis<br clear="none" class="">> > ><br clear="none" class="">> > > co-chair DB-WG<br clear="none" class="">> > ><br clear="none" class="">> > ></div></div></div> </div> </div></div></div></blockquote></div><br class=""></div></body></html>