[farsiweb]Some sorting problems

2002-06-23 Thread C Bobroff
> 2. The Waw(U-0648) is after the 'Heh' (U-0647). > I have no idea for the second > problem. > Thanks for posting this problem! I have been wondering what effect the fact that the Arabic and Persian alphabets have different ORDER of letters would have on all this. Now I got my answer! (And of c

[farsiweb]Some sorting problems

2002-06-22 Thread Hamidreza Younesy Aghdam
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, varch