Share via

ADF Copy Activity Encoding UTF-8-BOM

Jay 556 Reputation points
2020-10-19T16:08:33.937+00:00

I have to ftp a file using Copy Activity, file is encoded as UTF-8-BOM, which encoding should I use in Azure to make this work OK?

33317-utf8bom.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,893 questions
Accepted answer
  1. Vaibhav Chaudhari 38,666 Reputation points
    2020-10-20T06:39:44.827+00:00

    You may try just the UTF-8 encoding and see if it works. I could see this in the dataset for delimited text file in ADF

    33506-image.png

    ----------

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Josh Ashwood 71 Reputation points
    2021-03-16T12:08:32.07+00:00

    yeah, that doesn't work.
    The default UTF-8 encoding mentioned saves the file with a byte order mark incompatible with Data Factory's own json components.
    Nice.

    0 comments