December 16, 2009 at 8:41 am
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:-)
December 16, 2009 at 2:39 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply