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 |