If the query condition of sql server contains Chinese, the record cannot be found, what's the matter?

hry1982

In sql server.
Execute select * from Book where BookName like'%C language%', no record
There are definitely records in the table, but I can't find it, remove the Chinese,
Change to select * from Book where BookName like'%C%' to find,
It feels strange, execute select'test' in the query analyzer, and two question marks are displayed
What's going on? How to solve it?

我是杀人狂

try:
select * from Book where charindex('C language',bookname)>0

waxiaoning

gb2312
unicode

cv4bf5d65fd

Is your system font Chinese?
What is the database character set?

hry1982

Open the table directly in the database to display Chinese, insert and update Chinese can be used, just select

lone_lau

select * from Book where BookName like N'%C language%'

hry1982

Thanks, it's okay, but I still don't know what's going on

我的真实想法

What to do without adding N?