Question Re: How to Load Varchar data in VarBinary Column in SQL using BODS? in Technology Q&A

How to Load Varchar data in VarBinary Column in SQL using BODS?

Former Member — Tue, 27 Jun 2017 12:18:21 GMT

Hi,

I am getting error while loading data from var-char source column to var-binary column from SQL target database.

Its saying to use CONVERT functions, so please help.

Thanks

Parijatam

Re: How to Load Varchar data in VarBinary Column in SQL using BODS?

Former Member — Wed, 28 Jun 2017 04:48:39 GMT

As per Data Services reference guide, the conversion from varchar to varbinary(SQL Server Target data type) is not supported.

1752227 - What are the Data Type conversions for Microsoft SQL Server - Data Services

Regards

Arun Sasi

Re: How to Load Varchar data in VarBinary Column in SQL using BODS?

Former Member — Thu, 29 Jun 2017 10:26:11 GMT

Hi Arun ,

Thanks for your answer. My real problem is I am migrating data from Oracle (CharSet-AL32UTF8) to MS-SQL which be default stores data in UTF-16 if we select datatype as Nvarchar. So I would like to know will there be any loss of data for Chinese/Korean or Japanese text when migrating from Oracle to MS-SQL.

And the reason why I asked for VarBinary, as I read in some other link to user it for storing data in such type of column to come over such scenario.

Thanks,Parijatam

Re: How to Load Varchar data in VarBinary Column in SQL using BODS?

Former Member — Fri, 30 Jun 2017 07:44:13 GMT

You need to make sure that the data type of the column containing unicode characters is set to NVARCHAR(X)

When you migrate the data below will be data types in SQL Server Database

Regards

Arun Sasi