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 5, 2012 3:19 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 4:25 AM
Points: 143, Visits: 653
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


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 @ 11:15 AM
Points: 3,964, Visits: 5,204
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