top | item 34971385 (no title) samwestdev | 3 years ago Wait, there is no Unicode support in SQLite? discuss order hn newest simonw|3 years ago 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.txtYou 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|3 years ago Not by default. You can build it with the SQLITE_ENABLE_ICU flag to get Unicode support. HideousKojima|3 years ago There is, the extension listed there is specifically for case-insensitive comparison of unicode strings.
simonw|3 years ago 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.txtYou 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|3 years ago Not by default. You can build it with the SQLITE_ENABLE_ICU flag to get Unicode support.
HideousKojima|3 years ago There is, the extension listed there is specifically for case-insensitive comparison of unicode strings.
simonw|3 years ago
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|3 years ago
HideousKojima|3 years ago