Share via

Azure data studio will not bulk insert in UTF-8 encoding

Anonymous
2023-11-26T19:00:32.81+00:00

Dear members,

I am using the newest version of Azure Data Studio on Mac. I have tried bulk inserting UTF-8 encoded CSV file into a table. I have specified all columns as Varchar datatype, which is UTF-8 compatible. I also changed the collation of the table to Latin1_General_100_CI_AS_SC_UTF8. Unfortunately, I am still getting bad results as you can see in the screenshot. Also, I cannot specify what encoding I want in the importing due to my system OS.

What am I doing wrong, or how to fix this?

Thanks

Snímek obrazovky 2023-11-26 v 19.58.51

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
43,613 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
138 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.