Is there a way fix the � problem in postgres database:
As you can see there are names with accents and are not displayed corretly in the database. I would like to know if there is a way to fix this without dropping the database and restoring it... ?
When I execute
SELECT CAST (userfirstname AS bytea) FROM tab WHERE id = 42;`
this is the result i get:
bytea
--------------------------------------
\x5374efbfbd7068616e696520284d6d6529
(1 ligne)