Sorting Khmer Unicode text

Question

User1595108460 posted
Hello all. We are currently procing software where all data entry and text display is done in Khmer Unicode. Khmer is the National language of Cambodia. Khmer Unicode is does not make part of Windows XP, also not after (optionally) enabling support for South East Asian languages. Our software's target operational platform is XP. We would ideally like to enabled sorting by extending the default collation options in SQL Server 2005 (Express edition in this specific case). So the first question, is it posible to create your own sort SQL Server sort order indexes (formally we'r talking "collation" I believe). This would avoid having to sort lists at application/C# level. The next question, if option one is not feasible, is someone familiar with this issue for another language and/or can someone recommend a sort algorithm that can be used in C#. I've been looking into generic lists (List, Dictionary, Collection) but whatever I try it all seems to be very inefficient in terms of the algorithms I use(processing-time wise). Any help would be much appreciated. Tim van der Schaaf MOOR Software Development Co., Ltd.

Answer 1

User1524123963 posted

There's a series of articles from 2005 about this on Michael Kaplan's blog:

 http://blogs.msdn.com/michkap/search.aspx?q=Extending+collation+support&p=1

Hope that helps
Finn 

Answer 2

User1595108460 posted
Finn, thanks a lot for pointing me to the articles. Me and my colleague will review the articles and post here if we find a solution. Thanks Tim.