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

XMLWordPrintable

    • 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

            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3051982 ] New: JAC Suggestion Workflow 3 [ 3680803 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2614298 ] New: JAC Suggestion Workflow [ 3051982 ]
            Rachel Lin (Inactive) made changes -
            Workflow Original: JIRA PM Feature Request Workflow v2 - TEMP [ 2577958 ] New: Confluence Workflow - Public Facing v4 [ 2614298 ]
            Status Original: Closed [ 6 ] New: Resolved [ 5 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2357399 ] New: JIRA PM Feature Request Workflow v2 - TEMP [ 2577958 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 2124763 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2357399 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - TEMP [ 2087165 ] New: JIRA Bug Workflow w Kanban v6 [ 2124763 ]
            Katherine Yabut made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 890314 ] New: JIRA Bug Workflow w Kanban v6 - TEMP [ 2087165 ]
            jonah (Inactive) made changes -
            Description Original: 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

            		New: {panel:bgColor=#e7f4fa}
              *NOTE:* This suggestion is for *JIRA Server*. Using *JIRA Cloud*? [See the corresponding suggestion|http://jira.atlassian.com/browse/JRACLOUD-39970].
              {panel}

            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

            jonah (Inactive) made changes -
            Link New: This issue relates to JRACLOUD-39970 [ JRACLOUD-39970 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels Original: Fug expedite New: Fug affects-server expedite

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

                Created:
                Updated:
                Resolved: