SQL ENCODING In SQL Management Studio

Question

We have a trilingual system at work, English, Greek and Russian. I have a problem with Russian when I update some fields in my database. If I use the update request to update the default form of the field in English, I get '??????????' instead of Russian characters. If I update them manually, it will show 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 solve your problem