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.