Hi @Dinesh Melapadi ,
Welcome to Microsoft Q&A forum and thanks for reaching out here.
Could you please confirm how are you trying to load the data to your Dedicated SQL server? Are you using ADF or Synapse Copy activity or some other process.
In general, you will have to prefix N before the string literal so that the value will be handled as Unicode instead of non-Unicode. Please see below:
In case if you are using Copy activity make sure to set the source dataset Encoding settings to UTF-8
as below:
Hope this helps. Let us know how it goes.
Thank you
Please don’t forget to Accept Answer
and Yes
for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.