'How to copy the national language characters into the table

I have a language_lookup table like below,

enter image description here

And I have a language_details table like below,

enter image description here

My objective is to copy the regional_names from language_lookup table and insert it into the language_table. But when I try to do that, all non-english characters are converted into ? Question marks.

The current output which I am getting is,

enter image description here

The query I am using,

update ld
set ld.regional_name = ll.regional_name
from language_details ld
inner join language_lookup ll on ll.language = ld.language

Is there any way to convey SQL server that ll.regional_name is national language, something similar to,

set ld.regional_name = [N] ll.regional_name 

Note: I have set the datatype as NVARCHAR(50) for both columns.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source