Farsi Collation

I've installed SQL Server 2000 with Arabic collation during the
installation. Yet, I'm not able to search for Farsi strings. What
should I do?topolou (topolou2000@.yahoo.com) writes:
> I've installed SQL Server 2000 with Arabic collation during the
> installation. Yet, I'm not able to search for Farsi strings. What
> should I do?

Unfortunately there is no Farsi collation for SQL Server, but the Arabic
collations are as close as you can come. I have learnt that these
collations does not sort Farsi correctly.

Why you cannot find Farsi data I don't know, but note that you need
to delelimit Unicode literals with N'', for instance N'nisse'.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp