This will be short and sweet. Hopefully it will be useful to some of you,
As you may or may not know, the country formerly known as Turkey recently changed its official name to Türkiye, even in English. However, when sorting by country name, it should appear between Tunisia and Turkmenistan rather than later in the list. (Official U.N. sorted list can be found here.)
In the weeks following this change, I was asked on at least five separate occasions to look at sorting issues that arose. Please accept my apologies in advance if you already know what I'm about to write. I, myself, thought that it was common knowledge, but recent experience has shown otherwise.
Below, I'll explain how I correctly sort by country within Oracle. This technique can also apply to any other data (names, etc.) that need to take account of accented characters when sorting. I hope that it's useful to some of you.