I'm working on migrating Sybase ASE 15.7 SP134 database to SQL Server 2008R2, using SSMA for Sybase 2014.
I'm facing an issue where a table in SybaseDB has 2 columns with the data type
TEXT. The SQL Server table with datatype "text" is mismatching on Japanese data characters.
How can we keep same text as Sybase while migrating data?
How to keep Non-ASCII characters as it is during migration?
Please comment if more information can be provided.