Azure Synapse Dedicated SQL Pool for chinese language records

Dinesh Melapadi 60 Reputation points

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.

User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,826 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,518 questions
0 comments No comments
{count} vote

Accepted answer
  1. KranthiPakala-MSFT 45,902 Reputation points Microsoft Employee

    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:

    User's image

    In case if you are using Copy activity make sure to set the source dataset Encoding settings to UTF-8 as below:

    User's image

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful