InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 03:12:10 GMT20http://www.sqlservercentral.com/Forums/Topic835150-5-1.aspxTry to query as unicode data format:like N'上海精元机械有限公司' (or like N'%海精元机械有限公%' if you'd need to use wildcards)instead of like '上海精元机械有限公司'Hope that helps.Wed, 16 Dec 2009 14:39:56 GMTLutzMhttp://www.sqlservercentral.com/Forums/Topic835150-5-1.aspxselect * from dbo.TempCh where [customer name] like '上海精元机械有限公司' collate Chinese_PRC_CI_AI_KS_WSDefault Collation:SQL_Latin1_General_CP1_CI_AS[customer name] Column collation :Chinese_PRC_CI_AI_KS_WSI 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:-)Wed, 16 Dec 2009 08:41:52 GMTdksit_05