sql server LIKE problem with unicode

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:

Quote:

---

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

---

any ideas? :confused:

What collation is the column SHAIN_NAME?

Execute

Code:

---

sp_help 'area'

---

and post the column names and their collation here.

Try

Code:

---

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

---