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.

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)