unicode.md

unicode: Unicode support for SQLite

Implements case-insensitive string comparison for Unicode strings. Has no external dependencies (like libicu). Adapted from sqlite3_unicode.

Provides the following unicode features:

• upper() and lower() functions to normalize case.
• like() function and LIKE operator with case-independent matching.
• unaccent() function to normalize strings by removing accents.

Tries to override the default NOCASE case-insensitive collation sequence to support UTF-8 characters (available in SQLite CLI and C API only).

Upper and lower

sqlite> select upper('привет');
ПРИВЕТ
sqlite> select nupper('привет');
ПРИВЕТ

nupper() is an alias for upper() in case the latter is already overridden by some other extension.

sqlite> select lower('ПРИВЕТ');
привет
sqlite> select nlower('ПРИВЕТ');
привет

nlower() is an alias for lower() in case the latter is already overridden by some other extension.

Case-insensitive LIKE

The pattern in like() function goes first:

sqlite> select like('пРиВ_Т', 'привет');
1

The pattern in LIKE operator goes second:

sqlite> select 'привет' like 'пРиВ_Т';
1

Unaccent

sqlite> select unaccent('hôtel');
hotel

Usage

Before:

sqlite> select upper('hello');
HELLO
sqlite> select upper('привет');
привет

After:

sqlite> .load ./unicode
sqlite> select upper('hello');
HELLO
sqlite> select upper('привет');
ПРИВЕТ

⬇️ Download • ✨ Explore • 🚀 Follow