alter column party_name nvarchar(max)
I am trying to insert below characters:
insert into landing.lnd_test (party_name)
values ('성 이름')
but in the table I see the values are replaced with '? ??'
.
How do I alter this column so I can see correct data?
I am using Microsoft SQL Server Management Studio 18
1条答案
按热度按时间omhiaaxx1#
Agreed to @Panagiotis Kanavos' comment, when importing data from flat file, if encoding is UTF8,
성 이름
is copied to SQL and displayed as is.I tried giving many encoding options, while using data factory to import flat file data. UTF-8 encoding gave the data as in source.
When different encoding is given, output looks like
When UTF-8 is given, the output looks like