Search should not be case sensitive

[dokuhebi]

Describe the bug

When searching, the results are different depending on capitalization.

To Reproduce

Steps to reproduce the behavior:

1. We have questions in our system, some containing the word "association" and others with information about Single SignOn ("SSO").
2. Run a search with "sso" (lower case), and only the "association" questions are returned.
3. Run a search with "SSO" (capitalized), and only the "SSO" questions are returned.

The behavior is inconsistent, since articles with "HADES" (all caps") do return if you search for "hades" (lower case).

Expected behavior

A search for SSO should return all results with the "sso" string, regardless of case.

Platform

• Device: Desktop
• OS: Windows 11
• Browser and version: Firefox 135.0.1
• Version: Answer version 1.4.2

[sy-records]

Thanks for your feedback. But I did not reproduce the issue.

Screenshots

[sy-records]

What Database engine are you using?

In case of MySQL, the database needs to use the utf8mb4_general_ci, utf8mb4_bin is case sensitive.