Warn about unsupported database encoding/collation during installation, upgrade and startup

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Won't Do
    • None
    • Component/s: None
    • 1
    • 10

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? 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

      1. Installation
      2. Upgrade
      3. 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   | 
+--------------+----------------------------------+

            Assignee:
            Unassigned
            Reporter:
            BejoyA
            Votes:
            4 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: