Character set specific MySql query

[mjl4975]

Hi

I am trying to write a mysql query that is Japanese character set specific.

I want to be able to query the database on peoples family names using the Japanese alphabet.

SELECT LastName 
FROM friends 
WHERE sjis '‚_' COLLATE sjis_japanese_ci = '‚_'

I have tried this and different variations but have had no luck.

Any advice would be much appreciated.

Michael