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

Using C locale database collation causing certain value not searchable in the custom field

XMLWordPrintable

      Issue Summary

      This is reproducible on Data Center: (yes)

      Steps to Reproduce

      1. Create a DB using our official guide for PostgresDB 
        CREATE DATABASE jiradb WITH ENCODING 'UNICODE' LC_COLLATE 'C' LC_CTYPE 'C' TEMPLATE template0;
      2. Confirm the DB is using Database collation "C" locale type via Jira System Info.
      3. Create a new select list custom field.
      4. Add the following options: 
        Малый/средний бизнес
Частные лица
Карточные продукты “Лайт”
      5. Add the values to a few issues.
      6. Search the issue using basic search or advanced search: 
        "Select list" = "Малый/средний бизнес"
      7. Getting the following errors: 
        The option 'Малый/средний бизнес' for field 'Select list' does not exist.

      Expected Results

      It should allow to search any text from Cyrillic script.

      Actual Results

      Jira does not handle non-ASCII characters well

      Workaround

      Move the database collation to en_US.UTF-8 or C.UTF-8 follow the steps in the https://confluence.atlassian.com/jirakb/unsupported-collation-error-thrown-in-jira-server-using-postgresql-776657961.html

      Notes

      The bug is not affected the other Jira version such as 9.4, 9.12, 9.15 and 9.16

            [JRASERVER-77921] Using C locale database collation causing certain value not searchable in the custom field

            No work has yet been logged on this issue.

              Unassigned Unassigned
              ckimloong John Chin
              Affected customers:
              1 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated: