Hello! In the request, you must ignore the case of the text, so I traditionally use the UPPER in the request, like this:
“select * from data where
UPPER(ccusname) LIKE UPPER(’%” + document.childByName(“Search input”).content.text + “%’)”
The request is executed, but the operator does not work … why? Maybe the problem is in Cyrillic?
SQLite only supports case-insensitive comparisons of ASCII characters…
https://sqlite.org/faq.html#q18
For non-latin text you need to add ccusnameUpper column to table that contains uppercase (or lowercase) text.
"select * from data where ccusnameUpper LIKE '%" + document.childByName("Search input").content.text.toUpperCase() + "%')"