Implicit conversion from data type varchar to varbinary is not allowed.

[samsunggon]

can anyone help me to that error?
i just try to clear all items in vault using this sql script here
https://forum.ragezone.com/f197/verr...online-344193/
but give me error "Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query."

or any tutorials to clear all items in vault?
im using zteam s6ep3 files
sql server 2008r2

Thanks

[MentaL]

[cryy]

UPDATE warehouse SET Items = CAST(REPLICATE(char(0xff), 3840) as varbinary(3840)) WHERE AccountId = 'your account' 

But first you should design your warehouse table and check length of Items column and change 3840 accordingly

[Natzugen]

delete the warehouse column and create it again