Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-39970

Jira needs to check the collation of the DB before it starts

    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Jira needs a specific collation to make things work.

      We should have a check that for every DB Engine the proper collation is used.

      If not a BIG message should be written in the logs stating that some functionalities are not going to work because of this.

      For the different DBs the collations are :

      • Oracle : BINARY
      • Mysql: utf8_bin
      • Postgres : C or POSIX
      • SQL Server : SQL_Latin1_General_CP437_CI_AI or SQL_Latin1_General_CI_AI
      • HSQLDB : TBD

            [JRASERVER-39970] Jira needs to check the collation of the DB before it starts

              sbhuiyan shafqat
              ckhatchikian Carlos Khatchikian
              Votes:
              1 Vote for this issue
              Watchers:
              15 Start watching this issue

                Created:
                Updated:
                Resolved: