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

[hechmi]

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

[Anonymous]

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-v...

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 🙂

[hechmi]

@nthampi 

Tank you for your quick answers 

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

[akumar2301]

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

[hechmi]

@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

[akumar2301]

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.

[hechmi]

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

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

[hechmi]

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