H2 : how to insert/update a varbinary column

Question

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.

user8136440 · Accepted Answer · 2017-06-09 14:57:54Z

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'));

answered Jun 9, 2017 at 14:57

user8136440

Sign up to request clarification or add additional context in comments.

1 Answer 1