Output from Oracle (changing just NLS_LANG)
The first one is the same as Cache sorts/collates.
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
SQL> select * from distrito order by DESCRICAO;
ID DESCRICAO
---------- ------------------------------
1 AVEIRO
19 A�ORES
2 BEJA
3 BRAGA
4 BRAGAN�A
5 CASTELO BRANCO
6 COIMBRA
8 FARO
9 GUARDA
10 LEIRIA
11 LISBOA
20 MADEIRA
12 PORTALEGRE
13 PORTO
14 SANTAREM
15 SET�BAL
16 VIANA DO CASTELO
17 VILA REAL
18 VISEU
7 �VORA
20 rows selected.
NLS_LANG=PORTUGUESE_PORTUGAL.WE8ISO8859P1
SQL> select * from distrito order by descricao;
ID DESCRICAO
---------- ------------------------------
19 A�ORES
1 AVEIRO
2 BEJA
3 BRAGA
4 BRAGAN�A
5 CASTELO BRANCO
6 COIMBRA
7 �VORA
8 FARO
9 GUARDA
10 LEIRIA
11 LISBOA
20 MADEIRA
12 PORTALEGRE
13 PORTO
14 SANTAREM
15 SET�BAL
16 VIANA DO CASTELO
17 VILA REAL
18 VISEU
20 rows selected.
