On: sqlean: A set of SQLite extensions

[samwestdev]

Wait, there is no Unicode support in SQLite?

[simonw → samwestdev]

That depends on what you mean by "unicode support".

https://www.sqlite.org/datatype3.html notes that:

> TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).

But if you want unicode-aware collations, LIKE operations etc you need this extension: https://www.sqlite.org/src/doc/trunk/ext/icu/README.txt

You can compile this in too, but from a quick review none of my various SQLite installations seem to have been compiled with the SQLITE_ENABLE_ICU flag.

[cldellow → samwestdev]

Not by default. You can build it with the SQLITE_ENABLE_ICU flag to get Unicode support.

[HideousKojima → samwestdev]

There is, the extension listed there is specifically for case-insensitive comparison of unicode strings.