Hello, I want to write a byte array into a 'bytea' table field. This is the BLOB type of Postgres.
Writing the binary content seems to work properly as the fields content length is correct. I write using 'map.put(t.BINARYDATA,<bytearray>)' and the proper jooq sql statement. But when the record is read from the database the data is not given back the same way it was when writing it. Using 'bytes = record.getValue(t.BINARYDATA);' gives the bytes in hex-format. Eg. 'System.out.println(new String(bytes));' prints out: 'I504e470d0a1a0a0000000d4948445200000004000000040802000000269309290000000467414d410000b18f0bfc610...' Did I miss something or is this a problem with Postgres? Greetings Mike -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
