SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General / problem of " ی" in sql / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:43:03 GMT20RE: problem of " ی" in sqlhttp://www.sqlservercentral.com/Forums/Topic1380951-391-1.aspxHave you tried specifying the "Persian_" or "Persian_100_" [url=http://msdn.microsoft.com/en-us/library/ms188046.aspx]collations[/url]e.g.[code="sql"] select * from mtTable where theColumn COLLATE Persian_100_CS_AS LIKE '% ی%' COLLATE Persian_100_CS_AS[/code]Mon, 05 Nov 2012 04:13:27 GMTStewart "Arturius" Campbellproblem of " ی" in sqlhttp://www.sqlservercentral.com/Forums/Topic1380951-391-1.aspxhello all.I want to search "ی" in column of table in sql server 2008 but it dose not find "ی" and find shift+x that is arabic word.I want to find persian "ی" not arabic "ی"?please help me how do i do?Mon, 05 Nov 2012 03:19:44 GMTelham_azizi_62