All,
I have setup up Jira database for multiple QA instances. And I figured out a problem, that some of the database are case sensitive and some are not (look at example below for more clarity). Even after using the suggested collation as recommended by Atlassian.
(Option 1) Postgres is case sensitive, example -
"Select * from AO_0000_TABLE_NAME where COLUMN_NAME = A1"
returns 1 entry which include only A1. And no a1 records are returned.
(Option 2) SQL server 2019 is case insensitive, example -
"Select * from AO_0000_TABLE_NAME where COLUMN_NAME = A1"
returns 2 entries which include values a1, A1
Not an expert of database for Atlassian instances. Can anyone tell me which one of them is the returning correct values. And if I have to take a guess, Option 1 would be the choice I want in my DB.
-SG