[Fix] PG::CharacterNotInRepertoire: ERROR: invalid byte sequence for encoding “UTF8”
I was trying to store Random IVs generated for AES encryption but couldn’t store them into a PostgreSQL database.
The Random IVs generated were binary data. So, you have to escape them.
While storing, do this
PGconn.escape_bytea(data)
While retrieving, do this
PGconn.unescape_bytea(data)