Currently a sqlite orders text fields as Case Sensitive
=========SAMPLE SQL==========
SELECT * FROM(
SELECT 'Apple' AS name
UNION
SELECT 'apple' AS name
UNION
SELECT 'Banana' AS name
UNION
SELECT 'banana' AS name
)
ORDER BY name
=========RESULTS==========
Apple
Banana
apple
banana
Is there a setting or a different of changing this to Case In-sensitive
other than using UPPER:
=========SAMPLE SQL==========
SELECT * FROM(
SELECT 'Apple' AS name
UNION
SELECT 'apple' AS name
UNION
SELECT 'Banana' AS name
UNION
SELECT 'banana' AS name
)
ORDER BY UPPER(name)
=========RESULTS==========
apple
Apple
banana
Banana