error with ILIKE on libsql

I'm trying to use ILIKE clause on libsql and I receive a error. Repository to reproduce the error: https://github.com/emersonlaurentino/libsql-ilike-error

GitHub

Contribute to emersonlaurentino/libsql-ilike-error development by creating an account on GitHub.

2 Replies

Angelelz•13mo ago

SQLite doesn't have an ilike function, that is basically only available in postgres. See here: https://www.sqlite.org/lang_expr.html#operators_and_parse_affecting_attributes You might want to take a look at collation and/or the lower SQL function if you want similar functionality

EmersonOP•13mo ago

U're right, I'm noob with sqlite ecosystem, thanks for that.