After re-reading this:
(2) Oracle does the following:
Binary and Linguistic sorting:
Binary is the default.
Linguistic sorting is configured by setting NLS_COMP=LINGUISTIC and Setting
NLS_SORT to a language specific sort rule.
(these can be set at the session level or DB etc, via an alter session
command, alter system command or by environment variables)
As such there is no mechanism to change the sorting element for a single
column.
Case comparisons are handled by toupper, tolower and other sql functions are
plentiful. It also utilizes a "Blank-padded/ nonpadded" comparis when dealing
with VARCHAR vs CHAR datatypes. But that is probably out of scope since sqlite
is loosely typed.
(4). I like the following syntax:
SELECT * FROM t1 WHERE CAST(x AS TEXT COLLATE NOCASE)='HELLO';
As it pretty clearly modifies the "default" attribute.
Ken