'How to copy the national language characters into the table
I have a language_lookup table like below,
And I have a language_details table like below,
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,
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 |
|---|



