TEXT data migrate from Sybase to SQL Server

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.

-
Stop using text data types -- they're long deprecated. If you need to, use NTEXT instead to preserve Unicode characters. But that's not a great idea.

-
Do the smart thing and use NVARCHAR(MAX) instead, because that's not deprecated, and will handle your Unicode long text data just fine.

StackExchange Database Administrators Q#186952, answer score: 5