I tried to save a hardcoded value to a VARBINARY column, and it complained that I needed to use CONVERT function
Here’s the things I tried:
– CONVERT(VARBINARY, ‘0x43d3a4334af’) : Returns 0x2333 (something other than the value)
– CAST(‘0x43d4a4334af’ AS VARBINARY) : Returns 0x21231 (something other than the value)
– Copy from another row – worked, but not a solution
SET Column = 0x43d3a4334f (without quotes) – works!