problem of " ی" in sql

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » problem of " ی" in sql

problem of " ی" in sql

Rate Topic

Display Mode

Topic Options

Author

Message

elham_azizi_62

Posted Monday, November 05, 2012 3:19 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, April 27, 2013 5:33 AM
Points: 109, Visits: 390

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

Stewart "Arturius" Campbell

Posted Monday, November 05, 2012 4:13 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

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 »

Permissions