CI4 save base64 encoded value, but postgres later returns hex encoded value and base64 cant decode value
If in database handler write this code before get query, all is ok
$this->db->query('SET bytea_output = "escape"');
https://www.postgresql.org/docs/9.0/datatype-binary.html
I dont know how we must work with binary data in Postgres
https://prnt.sc/r1sng5
https://prnt.sc/r1snv9
https://prnt.sc/r1sot1
I have PostgreSQL v12
CI4 save base64 encoded value, but postgres later returns hex encoded value and base64 cant decode value
If in database handler write this code before get query, all is ok
$this->db->query('SET bytea_output = "escape"');https://www.postgresql.org/docs/9.0/datatype-binary.html
I dont know how we must work with binary data in Postgres
https://prnt.sc/r1sng5
https://prnt.sc/r1snv9
https://prnt.sc/r1sot1
I have PostgreSQL v12