iOS Question SQLite collate problem

[Pendrush]

This query work on Android, but not on iOS

SELECT * FROM table ORDER BY field COLLATE UNICODE

Error is:
ExecQuery error: no such collation sequence: UNICODE

Anyone know solution for UNICODE order?

 

[eps]

At a guess it's probably something to do with the version of SQLite. They're probably different between iOS and Android.

ETA : see here : https://github.com/yapstudios/YapDatabase/wiki/SQLite-version-(bundled-with-OS)

and here : http://stackoverflow.com/questions/2421189/version-of-sqlite-used-in-android

 

[Erel]

I think that your query will only work on Android 5+ which includes built-in support for the ICU SQLite module.