sql server LIKE problem with unicode

[n0vembr]

have anyone had any problem with sql server LIKE keyword?
im trying to build a searching module..the program is in Japanese.
problem is when I try to search using one Japanese character it will
display all records.. what am I missing?? :S

my query looks like this:

SELECT * FROM SHAIN_T WHERE shain_name LIKE '%SHAIN_INPUT%'

any ideas?

[kaffenils]

What collation is the column SHAIN_NAME?

Execute

sp_help 'area'

and post the column names and their collation here.

Try

SELECT * FROM SHAIN_T WHERE shain_name LIKE '%SHAIN_INPUT%' COLLATE {Name of collation from sp_help}