Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

problem of " ی" in sql Expand / Collapse
Author
Message
Posted Monday, November 05, 2012 3:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, March 05, 2014 10:52 PM
Points: 129, Visits: 478
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 05, 2012 4:13 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 6:40 AM
Points: 3,683, Visits: 4,818
Have you tried specifying the "Persian_" or "Persian_100_" collations

e.g.
 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