So I've been looking to install trac on my debian server with PostgreSQL. I setup everything as per the docs but when trying to run trac-admin /path initenv
I get this error for database encoding:
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
I get:
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!