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.
Questions are:
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.