[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)

 


So lazy that he can’t even fill this column out.

© 2015 Suhas Tech. All rights reserved.
Proudly powered by Wordpress.