Hi Erel.Both methods should work properly with any characters. Can you post an example that doesn't work for you?
-> SAO PAULO
Salvador
San Jose
Santiago
Sao Paulo
Singapore
Sofia
-> SÃO PAULO
-> São Paulo
Salvador
San Jose
Santiago
Sao Paulo
-> SAO PAULO
-> São Paulo
-> SÃO PAULO
Singapore
Sofia
dbCursor = dbSQL.ExecQuery("SELECT City, Country FROM Cities") ' ORDER BY City
dbCursor = dbSQL.ExecQuery("Select City,Country FROM Cities ORDER BY (CASE SUBSTR(City,2,1) WHEN 'Ã' THEN REPLACE(City,'Ã','a') " _
& " WHEN 'ã' THEN REPLACE(City,'ã','a') ELSE City END) COLLATE NOCASE")
Thank you very much, @Mahares .Here is your project zipped modified to accommodate any name with with any accents. It will do exactly what you want. Please add the JavaObject library. Every code I added has this comment next to it: '1/27/15 Mahares
Please run it and let us know. And if you still want Erel to respond to you, of course he will.