Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Sort order different in Sql server and .net - Korean Collation
19 views
Skip to first unread message
HemaVenkatesh via DotNetMonster.com
Mar 31, 2010, 11:41:12 PM3/31/10
to
I have a sql server table and in one of the unicode column i have English
text as well as Korean text. When i sort the table on that xolumn by
specifying collation Korean_Wansung_CI_AS, the records are sorted in a
particular order. Now i read the table in my .net interface into a grid view
and try to sort it by specifying the culture "ko_KR" expecting to see the
same sort order. But the sort order is different. I am not sure if i am
missing any settings. Can someone help ?
text as well as Korean text. When i sort the table on that xolumn by
specifying collation Korean_Wansung_CI_AS, the records are sorted in a
particular order. Now i read the table in my .net interface into a grid view
and try to sort it by specifying the culture "ko_KR" expecting to see the
same sort order. But the sort order is different. I am not sure if i am
missing any settings. Can someone help ?
--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-internationalization/201003/1
0 new messages