Disable letter case?

Question

WPF

Good evening, guys, how can I turn off the case of letters, it's just that it really interferes in the search
SELECT * FROM table WHERE NAME LIKE '%Текст%'
if there are "test", "test", "TEST", "Test" in the database, it does not find them.
How can this problem be solved?

Answer 1

MySQL: https://stackoverflow.com/questions/18853452/sql-s...
Postgresql: https://www.postgresql.org/docs/current/static/fun...

Answer 2

depending on the dialect

SELECT * FROM table WHERE name ILIKE '%Текст%'; -- надежнее всего

SELECT * FROM table WHERE LOWER(name) LIKE LOWER('%Текст%'); -- тут правильнее casefolding, но увы

or set the desired case insensitive collation (there are many options).