Of course, by default SQL keywords and identifiers are case insensitive. In additional, SQLite LIKE is case-insensitive only for ASCII.
However, case-sensitive identifiers can be enabled in PostgreSQL, but not SQLite.
https://en.wikibooks.org/wiki/SQL_Dialects_Reference/Data_structure_definition/Delimited_identifiers
Situation helps greatly, if you can compile your own SQLite, perhaps natively, or with Rust or Golang.
As for unicode-enabled SQLite case-sensitive LIKE, I have seen people compile their own COLLATION in Rust.
Top comments (0)