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

Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.

Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

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 Jan 9, 2025

Was this helpful?

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