Different collation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » Different collation

Different collation

Rate Topic

Display Mode

Topic Options

Author

Message

dksit_05

Posted Wednesday, December 16, 2009 8:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 23, 2009 6:08 AM
Points: 7, Visits: 78

select * from dbo.TempCh where [customer name] like '上海精元机械有限公司' collate Chinese_PRC_CI_AI_KS_WS

Default Collation:SQL_Latin1_General_CP1_CI_AS

[customer name] Column collation :Chinese_PRC_CI_AI_KS_WS

I have record in TempCh with '上海精元机械有限公司' customer name.
but in my above query i do not get row.
What to do ? Any one has idea?

Thanks
Darshan Shah Smile

Post #835150

LutzM

Posted Wednesday, December 16, 2009 2:39 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731, Visits: 12,131

Try to query as unicode data format:
like N'上海精元机械有限公司' (or like N'%海精元机械有限公%' if you'd need to use wildcards)
instead of
like '上海精元机械有限公司'

Hope that helps.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function

Post #835456

« Prev Topic | Next Topic »

Permissions