[farsiweb]Some sorting problems

[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 course, as usual can not
be helpful in solving the technical problem...)
-Connie

___
FarsiWeb mailing list
[EMAIL PROTECTED]
http://lists.sharif.edu/mailman/listinfo/farsiweb

[farsiweb]Some sorting problems

[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,
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