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

Different collation Expand / Collapse
Author
Message
Posted Wednesday, December 16, 2009 8:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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


Post #835150
Posted Wednesday, December 16, 2009 2:39 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 1:20 PM
Points: 7,161, Visits: 13,229
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 »

Add to briefcase

Permissions Expand / Collapse