This was the best result so far that reflected czech characters and IMHO correct sorting.
select * from test6 order by NLSSORT( (NAME),’NLS_SORT=Xczech‘)
|
|
||
|
46 |
46 |
d |
|
47 |
47 |
D |
|
134 |
134 |
dra |
|
136 |
136 |
Dra |
|
139 |
139 |
dráb |
|
138 |
138 |
Dráb |
|
140 |
140 |
drábek |
|
141 |
141 |
Drábek |
|
128 |
128 |
drasnar |
|
126 |
126 |
Drasnar |
|
135 |
135 |
draš |
|
137 |
137 |
Draš |
|
129 |
129 |
drašnar |
|
132 |
132 |
drašnár |
|
127 |
127 |
Drašnar |
|
133 |
133 |
Drašnár |
|
143 |
143 |
držák |
|
142 |
142 |
Držák |


