How to transform to lowercase a value in SQLite?
For anyone else that arrived here from Google looking how to select as upper case in SQLite, as expected, this will work:
sqlite> SELECT UPPER("Hello, WORLD!");HELLO, WORLD!
SQLite has a LOWER
function for this:
sqlite> SELECT LOWER("Hello, WORLD!");hello, world!
The lower(X) function returns a copy of string X with all ASCII characters converted to lower case. The default built-in lower() function works for ASCII characters only. To do case conversions on non-ASCII characters, load the ICU extension.