您可以在 ORDER BY 中使用 COLLATE NOCASE 子句，以便排序不区分大小写:>

You can use the COLLATE NOCASE clause in ORDER BY so the sorting is case insensitive:

SELECT * 
FROM medicine 
ORDER BY name COLLATE NOCASE ASC

查看演示.
结果:

See the demo.
Results:

| name       |
| ---------- |
| ADRENALINE |
| Adrenaline |
| adrenaline |
| BETALOC    |
| Betaloc    |
| betaloc    |
| CAPTOPRIL  |
| Captopril  |
| captopril  |