2 ms·
That depends on what you mean by "unicode support". https://www.sqlite.org/datatype3.html https://www.sqlite.org/datatype3.html notes that: > TEXT. The value
by simonw 4y ago
That depends on what you mean by "unicode support".
https://www.sqlite.org/datatype3.html 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 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.