JIRA throws Character 0xe28099 of encoding "UTF-8" has no equivalent in "LATIN1" when inserting Right Single Quatation Mark

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When Right Single Quatation Mark characters is inserted into JIRA, it will throws the error 'Character 0xe28099 of encoding "UTF-8" has no equivalent in "LATIN1"' in the JIRA UI. 

Diagnosis

Check in the JIRA PostgreSQL database the character encoding used. Following command can be used to check the client and server side encoding used by JIRA database:

show client_encoding;
show server_encoding;

(info)  one of it will return Character Encoding non-UTF-8. In this example, one of it will return Latin1.

Cause

in the PostgreSQL database, Client Side connection is using non-UTF-8 encoding while Server Side connection is using UTF-8.

Resolution

  1. set the character encoding used to UTF-8

    set client_encoding='UTF8';
  2. restart JIRA
Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.