There are two points you need to do:
- Define the type of the column as NVARCHAR for unicode.
- Append the N character before the string value in SQL statement, for example:

UPDATE myTable SET...