The default configuration of SQLite only supports case-insensitive comparisons of ASCII characters. The reason for this is that doing full Unicode case-insensitive comparisons and case conversions requires tables and logic that would nearly double the size of the SQLite library.
another one not mentioned there: sqlite is really tiny: (from https://sqlite.org/faq.html#q18 )