SQL ENCODING IN SQL Management studio

Question

Hi all

We have tri-lingual system at work, english,greek and russian. I have an issue with russian when i update some of the fields in my database. If i use an update query to update a field form the default english to russian i get '?????????' instead of the russian characters.if i update directly by hand it shown correctly. Help!

Answer 1

 step 1 : Use DATATYPE as NVARCHAR.
 Step 2 : put N before string your are inserting in your file 
          Example 

           insert into table( col1,col2) values (N'string1',N'string2')

will resolve your issue