we are not displaying data into SSMS grid.we are displaying data into .net gridview.

I had already checked , it is not an application issue.

we are using collation as Latin1_General_Bin in sqlserver. Is it the cause ?

When we run query of oracle in sql developer and paste the output of specific column in notepad++, it shows the LF character but

same out put of sqlserver does not show LF character in notepad++.

Still I am not able to find out the root cause why LF character is not shown in sqlserver, we migrated the data using SSMA from oracle to sqlserver .

Will we have to do some setting change in SSMA while migrating data of varchar column ?