DataError: character 0xe282ac of encoding "UTF8" has no equivalent in "LATIN1"
From further reading (and after seeing all my databases are set to encoding "LATIN1") it seems I need to change to UTF8, but how can I do this?
If I create my database like so:
createdb -U user -O user -E UTF8 trac
createdb: database creation failed: ERROR: encoding UTF8 does not match server's local en_GB DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
It looks like it should be easy to fix by changing the encoding but after searching for a bit I have no idea how to do this!