topic Re: The implicit conversion of the nvarchar data type to varbinary is not allowed in Talend Studio

The implicit conversion of the nvarchar data type to varbinary is not allowed

hechmi — Wed, 06 Mar 2019 08:51:45 GMT

Hi Alll;

i have problem to isert constant value (200) in colum type object .

i put it in the context but when i run job i have this problem :

The implicit conversion of the nvarchar data type to varbinary is not allowed. Use the CONVERT function to execute this query.

Best regards

Re: The implicit conversion of the nvarchar data type to varbinary is not allowed

Anonymous — Wed, 06 Mar 2019 09:01:01 GMT

Hi,

Could you please refer below community post and let us know whether it helped you?

https://community.talend.com/t5/Design-and-Development/PLEASE-HELP-MS-SQL-Server-varchar-change-to-varbinary/td-p/69120

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: The implicit conversion of the nvarchar data type to varbinary is not allowed

hechmi — Wed, 06 Mar 2019 09:18:20 GMT

@nthampi

Tank you for your quick answers

i try with your solution but not result, same problem . .Are you have other idea.

Re: The implicit conversion of the nvarchar data type to varbinary is not allowed

akumar2301 — Wed, 06 Mar 2019 10:32:51 GMT

@hechmi Why donot you read it as String instead of Object ?

Re: The implicit conversion of the nvarchar data type to varbinary is not allowed

hechmi — Wed, 06 Mar 2019 10:44:14 GMT

@uganesh

IN output table DB have type object

i want fix DRA=200 and CRA=0

When i insert direct in tmap i have this result in output table

CRA DRA

0x00000000 0x00000000
Best regards

Re: The implicit conversion of the nvarchar data type to varbinary is not allowed

akumar2301 — Wed, 06 Mar 2019 12:44:24 GMT

Try to read context as String , then before inserting in you table Convet it in byte[]
yourstring.getBytes()
Give a try . Not sure if this will help.

Re: The implicit conversion of the nvarchar data type to varbinary is not allowed

hechmi — Sun, 10 Mar 2019 10:46:31 GMT

IN output table DB have type object

i want fix DRA=200 and CRA=0

When i insert direct in tmap i have this result in output table

CRA DRA

0x00000000 0x00000000
Best regards