How do I migrate varbinary data to Netezza? I got a warning message while migrating DDL from SQL Server to Netezza:


  Warning: [dbo].[spec_binarymessage].[blobdata] data type [varbinary] is not supported the target system and will be scripted as VARCHAR(16000).


I'm wondering whether this kind of data conversion will cause some issues such as truncation of data etc.?
Best is to test it as Netezza does not support varbinary. So it has to be converted to a supported varchar(16000) or VARCHAR(64000), VARCHAR(n), NVARCHAR(16000), NVARCHAR(n).

Test your migration plan before hand.