DEV Community

Pacharapol Withayasakpunt
Pacharapol Withayasakpunt

Posted on

Case sensitivity in SQL

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)