Dear SQLite users,
I'd like to present you Unicode support extension i've implemented for
SQLite, it does full Unicode (6.3.0) collations, case mapping and
untailored ordering, and takes only ~100Kb to do that if you link it
statically. It's also open source and free (MIT license):
https://bitbucket.org/alekseyt/nunicode
What it does exactly:
sqlite> .load ./sqlite3/libnusqlite3.so
sqlite> SELECT 'MASSE' LIKE 'Maße';
1
sqlite> SELECT 'æ' LIKE 'AE';
1
sqlite> SELECT 'Masse' == 'Maße' COLLATE NUNICODE;
1
sqlite> SELECT upper('Maße');
MASSE
As you can see, this is truly full Unicode collation and case mapping
with untailored special casing. Extension provides the following
functions, statements and collations:
- upper()/lower()
- X LIKE Y ESCAPE Z
- COLLATE NOCASE
- COLLATE NUNICODE
Supported encodings: UTF-8, UTF-16 (host-endian), UTF-16BE, UTF-16LE.
If you wish to try it, you can find some pre-built binaries for Windows
and Linux in downloads section on BitBucket, documentation is embedded
into sources.
Any ideas?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users