ORDER BY ... COLLATE LOCALIZED

[kr580vm80a]

I had a need to embed the latest SQLite in my application. I have included your library and tried a simple query:

SELECT first_name
FROM clients
ORDER BY first_name COLLATE LOCALIZED

However, the data is sorted in the wrong order.
For example:

1.Євген
2.Андрій
3.Даніель
4.Орест

And it should be like this:

1.Андрій
2.Даніель
3.Євген
4.Орест

Does your framework support locales? I used "uk_UA". If so, what do I need to do to make the request sort the data in the correct order?

[mikehardy]

This is kind of a self-service repository because it's a mostly boring repackage, I say that because you'll have to be ready to roll your sleeves up and figure it out

You might find this interesting

sqlite-android/sqlite-android/src/main/jni/sqlite/README

Lines 27 to 31 in 25c5d9e

	The "LOCALIZED" collation and some miscellaneous user-functions added by the
	sqlite3_android.cpp module are not included. A collation called LOCALIZED
	that is equivalent to BINARY is added instead to keep various things working.
	This should not cause serious problems - class SQLiteConnection always
	runs "REINDEX LOCALIZED" immediately after opening a connection.

...and maybe this to play around https://github.com/requery/sqlite-android/blob/master/sqlite-android/src/main/jni/sqlite/Android.mk

[kr580vm80a]

Do you have an example of how this can be done? Thanks

[mikehardy]

Sorry @kr580vm80a no idea, c.f.

This is kind of a self-service repository because it's a mostly boring repackage, I say that because you'll have to be ready to roll your sleeves up and figure it out

Not our use case, so no experience with it