question

Jay-8106 avatar image
0 Votes"
Jay-8106 asked JoshA-7845 answered

ADF Copy Activity Encoding UTF-8-BOM

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
utf8bom.png (3.4 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Jay-8106,

Just checking in to see if the below answer provided by @VaibhavChaudhari helped. If this answers your query, do click “Accept Answer” and Up-Vote for the same. And, if you have any further query do let us know.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.


0 Votes 0 ·
Jay-8106 avatar image Jay-8106 PRADEEPCHEEKATLA-MSFT ·

Hi, Just waiting on recipient of the file to confirm OK as I don't have access to that end

0 Votes 0 ·

Hello @Jay-8106,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

Take care & Stay safe!

0 Votes 0 ·
Show more comments
VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered Jay-8106 commented

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


image.png (35.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you VaibhavChaudhari for the suggestion, I'll try UTF-8 and see if the recipient of the ftp file is happy with it, will let you know.

0 Votes 0 ·
JoshA-7845 avatar image
0 Votes"
JoshA-7845 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.