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.
MOOR Software Development Cambodia Co., Ltd.
#206a, Str. 63
Phnom Penh, Kingdom of Cambodia
Tel +855 (0)23 997 454
Mobile +855 (0)12 659 461
www.moorwebsoftware.com