You have to specify N before literals to say that to SQL that this is unicode.

Like in the below example :-

insert into Test(str)values(N'gîte')-- this is word for house in french.