You can configure the property value comparisons in query search conditions to be performed in a case-insensitive manner.
Content Platform Engine implements case-insensitive search behavior by including the LOWER function on the property and on the string value in query statements, so that the search condition becomes LOWER(property)=LOWER('Value'). However, for the following databases, the administration console cannot create supporting indexes in this way because the LOWER function is not supported on a column in an index:
You cannot force search behavior to be case-sensitive: in the absence of forced case-insensitivity, property value comparisons operate in a manner that is determined by the configured behavior of the underlying database. This underlying behavior might be case-insensitivity.
To set case-insensitive search behavior: