Do you consider to add support for ICU (SQLITE_ENABLE_ICU) in feature?

[pavelpoley]

Do you consider to add support for ICU (SQLITE_ENABLE_ICU) in future?

[simolus3]

I believe that option adds a dependency on the ICU library as well, which is fairly large. So I don't think enabling this would be a reasonable default.

Is there a particular feature of the ICU flag that you're looking for? Also, which platforms are you interested in? We could perhaps look into supporting a subset of that or point you to custom extensions for that.

[pavelpoley]

I use Kotlin SDK on Android platform.

I need ICU because the default SQLite LIKE implementation is ASCII-only, so it breaks as soon as you deal with real user text. Without ICU:

LIKE 'cafe%' doesn’t match "café"
Case-insensitive search fails for many languages
Unicode normalization differences aren’t handled
Non-Latin characters compare incorrectly

My app stores user-entered fields in many languages, so search must be Unicode-aware. ICU gives me proper case folding + accent-insensitive matching so users get correct results when typing “cafe”, “Cafe”, “CAFÉ”, etc.

I don’t need the full ICU feature set — just enough for reliable Unicode LIKE behavior.
The default Android sqlite supports this feature.

[pavelpoley]

Without this I will need to duplicate a "lower" column to every searchable column.