SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE "test" (
    "id"    INTEGER,
    "stuff" TEXT COLLATE NOCASE,
    PRIMARY KEY("id" AUTOINCREMENT)
);
✓
INSERT INTO test (stuff) VALUES ("0"), ("a"), ("z"), ("A"), ("Z");
✓
SELECT * FROM test ORDER BY stuff ASC;


id
stuff


1
0

2
a

4
A

3
z

5
Z


SELECT * FROM test ORDER BY CASE WHEN true THEN stuff END ASC;


id
stuff


1
0

4
A

5
Z

2
a

3
z


SELECT * FROM test ORDER BY stuff || '' ASC;


id
stuff


1
0

4
A

5
Z

2
a

3
z


SELECT * FROM test ORDER BY CASE WHEN true THEN stuff END COLLATE NOCASE ASC;


id
stuff


1
0

2
a

4
A

3
z

5
Z