How can I decode a “BYTES” value from the “ACT_GE_BYTEARRAY” table of default POSTGRES database?

Camunda 7 Topics Discussion & Questions
1

Its similar with https://forum.camunda.io/t/how-can-i-decode-a-bytes-value-from-the-act-ge-bytearray-table-of-default-h2-database/9787, but I’m using PostgreSQL

2

Hi Dan,
Postgresql offers a decode function.
You can try to do:
SELECT decode(your_bytes_column, 'hex') as your_text_column FROM ACT_GE_BYTEARRAY;

1 Like
3

Hello Enrico,
So, actually the function decode expects an string and not a bytearray column, you can see in docs: https://www.postgresql.org/docs/current/functions-binarystring.html

I’ve tried a lot and I’m stucked in that…

4

Assuming it is utf8-encoded text: convert_from(column, 'UTF8'). From the same reference that you shared.

5

I’ve tried it, does not works :confused:

6