Wt is the equalent datatype for nvarchar of SQLServer in Vertica database.when loading data from sql

M_Mahesh

What is the equivalent datatype for nvarchar datatype of SQL Server database in Vertica database. As when loading the nvarchar type data from sql server into vertica database, see the data difference.

Shobhit_Garg

Hi,

I think you should be able to use varchar datatype as it supports the multibyte characters.
Are you getting any kind of error while loading the data, if yes then let me know it. Which version of Vertica are you using?

Thanks

M_Mahesh

Hi Shobhit,

Yes, i used varchar datatype only. But i see only data difference not getting any error. 
"Vertica Analytic Database v7.0.1-0" this version we are using.

Shobhit_Garg

Hi Mahesh,

Could you show us the original data and point us the difference that you see after loading it into vertica.

Thanks

M_Mahesh

Hi Shobhit,
Thanks for your reply.
Orginal data in sqlserver:"福州市 " , after data load into vertica it looks like " ->->->".

Shobhit_Garg

Hi Mahesh,

How you are migrating the data from sql server to vertica, are you using informatica or some other tools for it.

Thanks,
Shobhit