Skip to Content

Implicit conversion from data type varchar to varbinary is not allowed

Hello @all,

I want to set a passwort for a SAP useraccount with MS SQL 2005.

But I get the following error:

update wt1.USR02 set BCODE = 'xxxxxxxxxxxxxxxxx' where BNAME = 'xxx' and MANDT = 'xxx'

Msg 257, Level 16, State 3, Line 1

Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.

On Oracle it works.

BCODE is a Hash.

Have anybody an idea?

Thanks for your help

Karsten

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 21, 2013 at 09:43 AM
    Add comment
    10|10000 characters needed characters exceeded