Dear All, I am trying to sort some data in SQL Server in the order of persian alphabet. As you may know, unfortunately the collations are not user defined (unlike some other DBs such as Oracle) and I can use only the system defined collations. Using 1256 instead of unicode (i.e. using char, varchar instead of nchar, nvarchar,... for the type of fields) i will have less problems. But there are still some (familiar) problems remaining:
1. In the standard keyboard, The default code for kaf is U-06A9 (KEHEH) which is even after the default code for YEH, so for example the word "Kazem" will be sorted after "Yaghoob". 2. The Waw(U-0648) is after the 'Heh' (U-0647). I think I may solve the first problem (KEHEH) if I do some system programming to change the default code for "Keheh" to "Keh" (U-0643). I wanted to know if any body has done the same task before (e.g. a recent version for kbdfa.dll). I have no idea for the second problem. Thanks in advance and looking forward to hearing from you. ===== ....../--/| /--/|................................... ...../ /_// / /.................................. ..../ / /amidreza Younesy Aghdam .../ ___ / / Emails : [EMAIL PROTECTED] ../ /|_/ / / [EMAIL PROTECTED] ./__/ //__/ /omepage:http://ce.sharif.edu/~younesy .|__|/ |__|/....................................... __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com _______________________________________________ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb