How to query with multibyte characters set in SQL Server 2012

manish23588

New Member

Join Date: Oct 2014

Posts: 1
#1

How to query with multibyte characters set in SQL Server 2012

Oct 16 '14, 07:34 AM

select interid from Messages where (text like '%あなたの机に201 4-10-16-11-31-41%'
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Oct 17 '14, 04:45 AM

Try to handle it using collation. Group the character set together and use OR operator for the other character sets.

Good Luck!!!

~~ CK
Comment

Comment