I don't think there should be any difference between sortings in
phonebooks, listings, and so on, but I'll keep looking. About the code
page, you're right, but the order in the code page is not correct. As
you can see in the list, some characters are not in orther (in fact, the
four persian characters: P, CH, ZH and G), and at the end the two
letters V and H are misplaced. But in Windows, 1256 is the only
character set which is appliable to both Arabic and Farsi.
PS: I can send you a sample database, with the correct order in an
integer field if your mailbox accepts attachments. Does it help you?
Peter Jacobi wrote:
> Hi Iman Biglari,
> Iman Biglari <ibiglari@...> wrote:
>> I don't know how to proide the order, because in Arabic and Farsi the
>>characters change when they are mixed together. Anyway, I'll write the
>>persian alphabet in the order they should be, with their UNICODE number. I
>>hope you can use this information. Let me know if there's anything else I
>>U+0622 (0xC2): Ø¢
>>U+0627 (0xC7): Ø§
>>U+0628 (0xC8): Ø¨
> Thank you for collecting this list. I assume I can get a first
> approximation working, based on this list, which is better
> than the current situation.
> But I suspect, there may be more things which must be observed, when
> aiming for complete consistencies with Arabic dictionaries, library sorting
> or just phone books. Perhaps you can locate some article about this.
> And a most basic question:
> You seem to want a collation for the Windows 1256 code page. Do you think,
> this is the most often used character set for Arabic?
> Peter Jacobi
> This SF.Net email sponsored by Black Hat Briefings & Training.
> Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
> digital self defense, top technical experts, no vendor pitches,
> unmatched networking opportunities. Visit http://www.blackhat.com
> Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
If you want the RAINBOW, you have to pass through the rain.