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.