Checking Oracle Database Encoding Sort and Comparison
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Overview
The new Ranking system (often called Lexo Rank) requires specific database configuration in Oracle. Follow the steps below to check the current configuration.
Run the following SQL to check on the database sort and comparison setting, Expected value is (BINARY)
SELECT * FROM nls_session_parameters WHERE parameter IN ('NLS_COMP', 'NLS_SORT'); SELECT * FROM nls_database_parameters WHERE parameter IN ('NLS_COMP', 'NLS_SORT'); SELECT SYS_CONTEXT('USERENV','NLS_SORT') nls_sort FROM DUAL;Run the following SQL to check on the database collation, Expected value is `AL32UTF8`
SELECT * FROM nls_session_parameters WHERE PARAMETER='NLS_CHARACTERSET'; SELECT * FROM nls_database_parameters WHERE PARAMETER='NLS_CHARACTERSET';
Resolution
If the SQL result is not returning the expected result, contact your local DBA to change the configuration as per the expected result.