locked
Sorting Khmer Unicode text RRS feed

  • 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.
    Tuesday, May 15, 2007 8:32 AM

Answers

  • 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 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 17, 2007 5:04 AM

All replies

  • 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 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, May 17, 2007 5:04 AM
  • 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.
    Monday, May 21, 2007 7:18 AM