关于iOS中sqlite No such collation sequence: LOCALIZED

No such collation sequence: LOCALIZED；

之前为了处理终端人员数据排序的问题，发现android与iOS中，sqlite 语句对

LOCALIZED

支持程度不一致，所以特意记录下来，以备后来人可以快速了结此类问题。原文如下（引自 https://github.com/sqlitebrowser/sqlitebrowser/issues/54）：

yes this is an android feature:

Localized Collation - ORDER BY
In addition to SQLite's default BINARY collator, Android supplies two more, LOCALIZED, which changes with the system's current locale, and UNICODE, which is the Unicode Collation Algorithm and not tailored to the current locale.

see: http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html

sqlite defines some functions to add your own collations: http://www.sqlite.org/c3ref/create_collation.html

确实，因为我们把同样的sql放到 Navicat Premium 也是不能执行通过的，但是在android上运行OK ，特此记录