0

I'm newbie to h2, I tried to update a varbinary(255) column, using the responses of those questions :Q1, Q2, but it doesn't work I get this message:

Hexadecimal string contains non-hex character: "test"; SQL statement: UPDATE TABLE set COLUMN=CAST('test' AS VARBINARY(255)) [90004-176] 90004/90004

can anyone help ?.
thank you.

aName
  • 2,751
  • 3
  • 32
  • 61

1 Answers1

0

I find the solution my self, for those who face the same issue here is what to do :

UPDATE TABLE SET COLUMN= FILE_READ('FILE.extension'));