JIRA throws Character 0xe28099 of encoding "UTF-8" has no equivalent in "LATIN1" when inserting Right Single Quatation Mark
症状
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.
診断
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;
one of it will return Character Encoding non-UTF-8. In this example, one of it will return Latin1.
原因
in the PostgreSQL database, Client Side connection is using non-UTF-8 encoding while Server Side connection is using UTF-8.
ソリューション
set the character encoding used to UTF-8
set client_encoding='UTF8';
- restart JIRA