Details
-
Bug
-
Resolution: Unresolved
-
Low
-
None
-
7.0.2
-
7
-
1
-
Severity 3 - Minor
-
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
- is related to
-
JRASERVER-43514 incorrect warning about use of C.UTF-8 collation
- Closed
- mentioned in
-
Page Loading...