While porting data from oracle to Azure sql database I am facing the following issue where, empty data in Oracle is converted as ➞➞➞ in SQL Server
Pic1: Data as in Oracle DB;
Pic2: Data as in Sql server DB;
Pic3: Data when pasted in Notepad++.
The character set in Oracle is
AL32UTF8 and that of target SQL Server database is
SQL_Latin1_General_CP1_CI_AS. I have tried changing the datatype to
NCHAR and changing the collation of the column to
SQL_Latin1_General_CP850_CI_AS, but no solution. What is the reason for this difference and is there any solution?