Are you inserting the data into a field with a data type that starts with N (such as NVarChar)? If not, you need to do that.

Next up, when you insert data, are you using an SQL statement to do that? If so, you need to put N before the quotes (eg: myfield = N'value')


If that is all OK, how are you looking at the data? Many programs (including database management tools) don't display unicode data, so will show ?? instead of the actual data - but the data will still be there (you just need to view it somewhere that supports unicode).