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
