SQLite Forum

Case-insensitive using 'ORDER BY'
Login
I'm confused a bit by the ORDER BY operator. I would like it to be case-insensitive. I already have enabled 'case_sensitive_like = 1' but this seems to only apply when using LIKE, and it does work as it should.

Is it possible to have the same feature available when doing an 'ORDER BY'? 
This CLI statement is NOT case-sensitive for 'name':
<code>
sqlite> select name,title from artists join cds on artists.artistid=cds.artistid where cds.genre like 'Amb%' and name like '%' order by name asc,title;
VA Hed Music|Hed Music 116
VA Hed Music|Hed Music 117
VA Hed Music|Hed Music 118
VA Hed Music|Hed Music 119
VA Hed Music|Hed Music 126
VA Hed Music|Hed Music 127
Zero 7|When It Falls
dZihan & Kamien|Gran Riserva (2002)
</code>

Perhaps I'm doing something wrong which is not surprising, I'm fairly new to sqlite. Any help is much appreciated.