Uploaded image for project: 'Jira Server and Data Center'
  1. Jira Server and Data Center
  2. JRASERVER-66236

Support PostgreSQL en_US.UTF-8 collation

    XMLWordPrintable

    Details

    • UIS:
      92
    • Support reference count:
      11
    • Feedback Policy:
      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.

      Description

      Problem Definition

      Currently, Jira only supports POSIX.UTF-8 or C.UTF-8 or C or POSIX as the collation.

      Suggested Solution

      Have Jira support *.UTF-8 collation (e.g. en_US.UTF-8, ja_JP.UTF-8) for PostgreSQL

      Why this is important

      Amazon AWS RDS has limited collation for PostgreSQL and en_US.UTF-8 is set as a default collation.

      Workaround

      Move to the supported collation referring to https://confluence.atlassian.com/jirakb/how-to-fix-the-collation-of-a-postgres-jira-database-776657961.html

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              4a4b131c106c Lukasz Gosiewski
              Reporter:
              znoorsazali Zul NS [Atlassian]
              Votes:
              88 Vote for this issue
              Watchers:
              62 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: