5 ms·
Wait, there is no Unicode support in SQLite?
by samwestdev 4y ago
Wait, there is no Unicode support in SQLite?
- cldellow 4y agoNot by default. You can build it with the SQLITE_ENABLE_ICU flag to get Unicode support.
- HideousKojima 4y agoThere is, the extension listed there is specifically for case-insensitive comparison of unicode strings.
- simonw 4y agoThat 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.