Loading...

XML

Word

Printable

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.

NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

Jira needs a specific collation to make things work.

We should have a check that for every DB Engine the proper collation is used.

If not a BIG message should be written in the logs stating that some functionalities are not going to work because of this.

For the different DBs the collations are :

causes

JRASERVER-43761 Collation check for Oracle is looking incorrectly at NLS_CHARACTERSET instead of NLS_SORT

is related to

JSWSERVER-11178 Unable to rank with any database collation that does not order all alphanumeric characters the same as ASCII

relates to

JRACLOUD-39970 Jira needs to check the collation of the DB before it starts

supersedes

JSWSERVER-11169 Fixing NLS_SORT for Jira Agile queries

(2 mentioned in)