-
Suggestion
-
Resolution: Fixed
-
None
NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.
JIRA is very sensitive to database encoding/collation which results in errors during upgrade as well as normal application functioning if the collation specified is not correct.
It would be easier for JIRA administrators if JIRA would warn of improper collation during
- Installation
- Upgrade
- Startup
The following are the SQL queries for checking database collation for the different supported databases:
Oracle: How to check database encoding for Oracle database
SQL> SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER='NLS_CHARACTERSET';
PARAMETER | VALUE
----------------------------------------------------------------------
NLS_CHARACTERSET | AL32UTF8
MySQL: How to check database collation for MySQL database
mysql> SELECT * FROM information_schema.SCHEMATA S where SCHEMA_NAME = "jiradb";
+--------------+-------------+----------------------------+------------------------+----------+
| CATALOG_NAME | SCHEMA_NAME | DEFAULT_CHARACTER_SET_NAME | DEFAULT_COLLATION_NAME | SQL_PATH |
+--------------+-------------+----------------------------+------------------------+----------+
| def | jiradb | utf8 | utf8_bin | NULL |
+--------------+-------------+----------------------------+------------------------+----------+
1 row in set (0.00 sec)
PostgreSQL: How to check database collation for PostgreSQL database
psql=# SELECT datname, pg_encoding_to_char(encoding), datcollate, datctype FROM pg_database WHERE datname = 'jiradb';
datname | pg_encoding_to_char | datcollate | datctype
---------+---------------------+-------------+-------------
jiradb | UTF8 | en_AU.UTF-8 | en_AU.UTF-8
Microsoft SQL Server: How to check database collation for MS SQL database
SELECT name, collation_name FROM sys.databases WHERE name='jiradb';
+--------------+----------------------------------+
| name | collation_name |
+--------------+----------------------------------+
| jiradb | SQL_Latin1_General_CP437_CI_AI |
+--------------+----------------------------------+
- is related to
-
- Closed
-
- Closed