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

Incorrect warning about the use of French_France.1252 collation on Windows

    XMLWordPrintable

Details

    Description

      Following JRA-43514, could you please also consider Windows version of POSTGRES where locale are taken from the OS

      For example in French the windows locale is French_France.1252, so database is created with following command

      CREATE DATABASE jira_db WITH ENCODING 'UTF8' LC_COLLATE='French_France.1252' LC_CTYPE='French_France.1252' TEMPLATE=template0 OWNER=jira_user;
      

      The warning is present in logs

      ****************************************************************************************************
      You are using an unsupported postgres72 collation: French_France.1252. This may cause some functionality to not work.
      Please use POSIX.UTF-8 or C.UTF-8 or C or POSIX as the collation instead.
      ****************************************************************************************************

      And this should not be the case as stated in Postgres documentation for Windows

      An important restriction, however, is that each database's character set must be compatible with the database's LC_CTYPE (character classification) and LC_COLLATE (string sort order) locale settings. For C or POSIX locale, any character set is allowed, but for other locales there is only one character set that will work correctly.
      (On Windows, however, UTF-8 encoding can be used with any locale.)

      The warning is not appropriate

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ee3ac3a54dd9 AGD CollabTools
              Votes:
              4 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: