Database Error When Creating a Pull Request
Environment
Postgres database
Symptoms
When creating a pull request from a project, the process fails with {{a database error has occurred}} message and the logs report:
Next Exception: org.postgresql.util.PSQLException: ERROR: character with byte sequence 0xef 0x88 0x90 in encoding "UTF8" has no equivalent in encoding "LATIN1"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338)
Cause
Your database client encoding is not using UTF-8.
Resolution
Set database client encoding to UTF-8
Check for the current encoding: show client_encoding;
Set the encoding: SET client_encoding = 'UTF8';
Ensure it's correctly set: show client_encoding;
Last modified on Nov 18, 2016
Powered by Confluence and Scroll Viewport.