Good day bros. I am trying to retrieve and store some user information from Twitter and store it in a psql db. The data comes back as a json string which I am decoding with mod JSON. Everything goes well until I try to insert the record into a psql db table (that has encoding UTF8) using the PgPP driver.
The string causing the problem is (undecoded in the JSON string returned by Twitter):
En d\u00e9mocratie, on a le droit d'avoir tort
And this looks fine in Komodo debugger once decoded, i.e. it shows the accented e. When I go to insert I get
DBD::PgPP::st execute failed: ERROR: invalid byte sequence for encoding "UTF8": 0xe96d6f Anyone know what's going wrong here or how to fix?