Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

problem of " ی" in sql Expand / Collapse
Posted Monday, November 5, 2012 3:19 AM


Group: General Forum Members
Last Login: Monday, December 7, 2015 5:10 AM
Points: 189, Visits: 820
hello 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?
Post #1380951
Posted Monday, November 5, 2012 4:13 AM



Group: General Forum Members
Last Login: Wednesday, October 5, 2016 12:14 AM
Points: 5,281, Visits: 7,008
Have you tried specifying the "Persian_" or "Persian_100_" collations

 select * from mtTable where theColumn COLLATE Persian_100_CS_AS LIKE '% ی%'  COLLATE Persian_100_CS_AS

Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1380968
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse