How to type Degree symbol (°) in Azure SQL data warehouse

I have data source like this:

1°18'19.74"N

But when I insert it to Azure data warehouse it look like this:

1�18'19.74"N

Answer

I tested using Data factory copy the csv data to SQL DW,

It works well.

The Sink table schema and data after pipeline executed:

Please modify your sink table data type to varchar() and test again.

Hope this helps.