Non latin letters are not accepted in a search filter

[boo-code]

Describe the Bug

Non Latin letters in the search filter do not work. No results are returned.

To Reproduce

1. Add a record with ą,č,ę,ė,į,š,ų,ū,ž or any other non-Latin letter.
2. Use a search field filter in the collection view to find the record with such a letter.

Errors Shown

No response

What version of Directus are you using?

9.8.0

What version of Node.js are you using?

16.14.2

What database are you using?

Postgres 14

What browser are you using?

Any

How are you deploying Directus?

Docker

[azrikahar]

I can't seem to reproduce this on my end, and I've tested both SQLite and Postgres as well:

chrome_l1KQyphpZj.mp4

Would you be able to test this with another database? just so we can be sure whether this only happen to this database specifically as I'm not sure how to best replicate this issue locally.

[boo-code]

Sorry, my fault. It's not the letters itself. The filter is case-sensitive. I had a word starting with Š and entered š in a filter. Then I got no results returned. So, actual problem is that the search field is case-insensitive, and the filter is case-sensitive. It creates confusion.

This issue should be changed to "case-sensitive filter confusion".

More letters for you to test case-sensitivity: Ą,Č,Ę,Ė,Į,Š,Ų,Ū,Ž.