Azure Synapse Dedicated SQL Pool for chinese language records

Question

I have requirement, client provides the Excel/csv files with records in Chinese language. Those files will be dropped in ADLS and we need to load it into Synapse Dedicated SQL Pool tables. I have tried with the sample but its not supporting. Based on the requirements can someone suggest how to load it into Synapse Dedicated SQL pool table with Synapse tables and the necessary changes to be done.

Answer 1

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.