Oracle SQL query – sort by Czech language

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

 

 

Jan D.
Jan D.

"The only real security that a man will have in this world is a reserve of knowledge, experience, and ability."

Articles: 669