Updating Unicode Data

Hi,

Could someone please tell me how to update data in a column that contains unicode data in SQL 2000?

I know how to write update scripts on my own, but when it comes to Unicode character updates I can�?ft manage. In the script that I have pasted below I can update the customer�?fs details, but this only works if I update with Romaji characters (non-unicode).

The data that I need to update is in Japanese Kanji, but when I use the 'Update' script below, the data is updated as all question marks (???????????).

Is it very much harder to get the script to where it will handle Unicode characters and insert the correct data?


UPDATE CUSTOMER_LANGUAGE_DETAILS
SET FIRST_NAME = '‰h�?s'
WHERE CUSTOMER_ID = 1592