Uploaded image for project: 'FOLIO'
  1. FOLIO
  2. FOLIO-1955

Create databases using und-x-icu collation

    XMLWordPrintable

    Details

    • Template:
    • Story Points:
      2
    • Development Team:
      Core: Platform

      Description

      These lines need to be added to the postgresql_db database creation task to enable und-x-icu collation (sorting):

      - postgresql_db:
          encoding: UTF-8
          lc_collate: und-x-icu
          lc_ctype: und-x-icu
          template: template0
      

      ICU collation is operating system independent.

      und-x-icu (for “undefined”) is the ICU “root” collation. Use this to get a reasonable language-agnostic sort order: https://www.postgresql.org/docs/current/static/collation.html
      "The CLDR root collation […] is used by all other locales by default, or as the base for their tailorings." http://www.unicode.org/reports/tr35/tr35-collation.html#Root_Collation

      This fixes the problem that spaces are ignored when sorting. See MODINVSTOR-149 for an example.

        TestRail: Results

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                  Dates

                  Created:
                  Updated:

                    TestRail: Runs

                      TestRail: Cases