Unanswered: Insert and retrive data as byte to/from BYTEA column
I have a table with column BYTEA and i am accessing the database using qt application.
My problem is i want to insert unsigned char array data into BYTEA column and retrive it as byte again.
I want to ASCII and Extended ASCII values also, so i am going to BYTEA datatype.
Using the following query i have inserted data into column:
INSERT INTO test (data) values (E'\\x8988');
In which i am storing as 0x89 as one byte and 0x88 as another byte.
But when i retrieve back using SELECT * from test;
The buffer contains: