TEXT data migrate from Sybase to SQL Server
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.