Currently, the database is using the default collation, which is case-sensitive. This means that when performing queries, the database distinguishes between uppercase and lowercase letters.
To resolve this, we need to update the collation of certain columns or the entire database to be case-insensitive.
Evidence
To showcase this issue, we created four sites within our application, each with a distinct name. The data retrieval process involved requesting the sites to be ordered by name. However, due to the case-sensitive collation, the ordering was not producing the expected results.
MarisiaS
commented
8 months ago
Currently, the database is using the default collation, which is case-sensitive. This means that when performing queries, the database distinguishes between uppercase and lowercase letters.
To resolve this, we need to update the collation of certain columns or the entire database to be case-insensitive.
Evidence
To showcase this issue, we created four sites within our application, each with a distinct name. The data retrieval process involved requesting the sites to be ordered by name. However, due to the case-sensitive collation, the ordering was not producing the expected results.