i need to select data from my sqlite database and i want the data should be ordered by a special column; my searches of the db should not be case_sensitive; my sql statement is like:
sqlite> .head on sqlite> select * from customlist order by name; customId|name X3F15C8HJ9|Bill Gates W2 DNVFWDR82J|DAWSON P7BWH9N705|H. Packard Y57SUQJX86|J.Michale.Chanel 2KK7N5QJLH|J.W. Bush 9Y1P3E02OR|Jack L5M0PO2YMU|John.Smego 5RU68C4KRY|dragongirl 66XDASL6YK|lisa CGF9F3BNXE|michel-Jackson i found the result is case_sensitive; i tried PRAGMA case_sensitive_like = 0; but it doesn't work; sqlite> PRAGMA case_sensitive_like = 0; sqlite> select * from customlist order by name; customId|name X3F15C8HJ9|Bill Gates W2 DNVFWDR82J|DAWSON P7BWH9N705|H. Packard Y57SUQJX86|J.Michale.Chanel 2KK7N5QJLH|J.W. Bush 9Y1P3E02OR|Jack L5M0PO2YMU|John.Smego 5RU68C4KRY|dragongirl 66XDASL6YK|lisa CGF9F3BNXE|michel-Jackson is there anyway to make the select result not to be case_sensitive? thanks!