All,
I have setup up Jira database for a instance. And I figured out a problem, that my SQL server 2019 db is returning case insensitive entires. It is setup with proper collation as recommended by Atlassian.
https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2019-1063561670.html
SQL server 2019 installed on Linux is case insensitive, example -
"Select * from AO_0000_TABLE_NAME where COLUMN_NAME = A1"
returns 2 entries which include values a1, A1
The problem is that the database should be returning case sensitive entries instead of being case insensitive. As mentioned in the above document.
- SQL Server uses Unicode encoding to store characters. This is sufficient to prevent any possible encoding problems.
Which i believe is not the case for Sql server 2019 installed on linux ubuntu.
Any help would be appreciated.
-SG