topic Re: Implicit conversion from data type nvarchar to varbinary is not allowe in Talend Studio

Implicit conversion from data type nvarchar to varbinary is not allowe

Anonymous — Sat, 16 Nov 2024 12:29:27 GMT

Hi All,
I am doing an ETL job to transfer from 1 data source to another, but unfortunately few of the column datatype is in Object. As I try to run the job, I got this error:
"Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query"
Can I know how to solve this issue to get rid from this error or how to use the convert function? I have try to read those thread who face the same problem like me but it does not work.
Thanks in advance =)
Mohd Fuzaimi

Re: Implicit conversion from data type nvarchar to varbinary is not allowe

Anonymous — Mon, 26 Dec 2011 02:50:10 GMT

Hi Mohd Fuzaimi
Which database do you use?
This issue is caused by wrong data type.
Maybe you choose a wrong column type by mistake.
Because i don't know details of your schemas, i can't figure out the wrong point.
Could you show me?
Best regards!
Pedro

Re: Implicit conversion from data type nvarchar to varbinary is not allowe

Anonymous — Mon, 24 Sep 2012 23:41:07 GMT

I have this error:
Disallowed implicit conversion from data type nvarchar to data type money. Use the CONVERT function to run this query.
I need insert values to a database

Re: Implicit conversion from data type nvarchar to varbinary is not allowe

janhess — Tue, 25 Sep 2012 13:13:20 GMT

Use the CONVERT function?

Re: Implicit conversion from data type nvarchar to varbinary is not allowe

Anonymous — Thu, 27 Sep 2012 00:26:01 GMT

I don't understand what it mean?

Re: Implicit conversion from data type nvarchar to varbinary is not allowe

Anonymous — Thu, 27 Sep 2012 00:27:46 GMT

Somebody resolved this error?

Re: Implicit conversion from data type nvarchar to varbinary is not allowe

Jesperrekuh — Mon, 14 May 2018 23:22:59 GMT

It comes down to :

You cannot perform this conversion using an ALTER TABLE statement since converting from varchar(max) to varbinary(max) requires an explicit conversion.

So you should follow these steps to alter your table:

Alter table with new column of VARBINARY(MAX)
If you have existing data in the VARCHAR(MAX) column, use update statement to add the data to the VARBINARY column
Alter table to drop the VARCHAR(MAX) column
Rename varbinary column to varchar name.

Sorry... it's DB limitation which makes sence due to the datatype in which it is stored.