Indeed, the choices are:
Arabic_BIN
Arabic_CI_AI
Arabic_CI_AI_WS
Arabic_CI_AI_KS
Arabic_CI_AI_KS_WS
Arabic_CI_AS
Arabic_CI_AS_WS
Arabic_CI_AS_KS
Arabic_CI_AS_KS_WS
Arabic_CS_AI
Arabic_CS_AI_WS
Arabic_CS_AI_KS
Arabic_CS_AI_KS_WS
Arabic_CS_AS
Arabic_CS_AS_WS
Arabic_CS_AS_KS
Arabic_CS_AS_KS_WS
And no Farsi in sight. :-(
Oh well, the 3rd party (being me!) solution still works....
michka
----- Original Message -----
From: "Michael (michka) Kaplan" <michka@trigeminal.com>
To: "Unicode List" <unicode@unicode.org>
Sent: Friday, July 28, 2000 9:12 AM
Subject: Re: SQL Server and Unicode
> It does indeed let them change the collation order to any that is on their
> "supported" list. I have to go to a meeting, but I will take a look later
on
> the Persian (Farsi) question but I do not remember it on the list so I
> suspect you are right.
>
> I have helped at least one client with utilities that create sort keys,
> interestingly enough for Farsi in SQL Server 7.0. My solution will keep
> working even if COLLATE cannot yet handle Farsi. :-)
>
> michka
>
>
> ----- Original Message -----
> From: "Roozbeh Pournader" <roozbeh@sina.sharif.ac.ir>
> To: "Michael (michka) Kaplan" <michka@trigeminal.com>
> Cc: "Unicode List" <unicode@unicode.org>
> Sent: Friday, July 28, 2000 9:11 AM
> Subject: Re: SQL Server and Unicode
>
>
> >
> >
> > On Wed, 26 Jul 2000, Michael (michka) Kaplan wrote:
> >
> > > SQL Server 2000 supports a COLLATE keyword that allows you to specify
a
> > > collation at the database or field level and thus choose a different
> > > language for such columns/indexes if you like (I discuss practical
> details
> > > and implications of this feature in an upcoming article in the Visual
> Basic
> > > Programmer's Journal, tentatively scheduled for November).
> >
> > Does is let the user choose the collation order? I've heard that it
> > doesn't support Persian well enough, and it doesn't allow modifications
of
> > sorting order. So people are stuck to Arabic sortings for Persian.
> >
> > --roozbeh
> >
> >
> >
>
>
This archive was generated by hypermail 2.1.2 : Tue Jul 10 2001 - 17:21:06 EDT