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

Jan Alexandr Kopřiva 0 Reputation points
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.
37,629 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.
106 questions
{count} votes