OleDB : ORDER BY 's order.

[Sin Jeong-hun]

com.CommandText="SELECT title FROM books ORDER BY title";
com.ExecuteReader();
......

The titles contain Alphabets, Hangeul(the Korean alphabets) and
numbers. The ORDER BY sorts titles in number-Hangeul-Alphabets order.
(Maybe this is because the system locale is Korean. I have ascertained
that when the Regional Options' Standard and formats are set to Korean,
the items in Windows Explorer are sorted in number-Hangeul-Alphabets
order and when English, number-Alphabets-Hangeul order)

Anyways, I want the ORDER BY always sort the title in
number-Alphabets-Hangeul order no matter what the system locale is. Is
there any way to do this?

If you are sure that there is no way to control the ORDER BY, just
please tell me that. Then I could stop wasting my time on this.

Thank you.

 

[Greg Young]

This post would probably be better suited in the appropriate database topic
area.

Cheers,

Greg Young
MVP - C#
http://codebetter.com/blogs/gregyoung

 

[John B]

com.CommandText="SELECT title FROM books ORDER BY title";
com.ExecuteReader();
.....

The titles contain Alphabets, Hangeul(the Korean alphabets) and
numbers. The ORDER BY sorts titles in number-Hangeul-Alphabets order.
(Maybe this is because the system locale is Korean. I have ascertained
that when the Regional Options' Standard and formats are set to Korean,
the items in Windows Explorer are sorted in number-Hangeul-Alphabets
order and when English, number-Alphabets-Hangeul order)

Anyways, I want the ORDER BY always sort the title in
number-Alphabets-Hangeul order no matter what the system locale is. Is
there any way to do this?

If you are sure that there is no way to control the ORDER BY, just
please tell me that. Then I could stop wasting my time on this.

Thank you.

As G.Y. said, it would be better in the relevant db group but...
You need to look at collations in the order by clause ie order by title
collate <number-Alphabets-Hangeul collation name>

in MS Sql Server it works as:
select * from fubar order by blah collate Albanian_BIN2

JB