[OT] SQLite/Unicode

Peter Haworth pete at lcsql.com
Mon Jul 6 17:01:04 EDT 2015


For those of you wanting to use Unicode with an SQLite database, I came
across this on the SQLite list:

https://bitbucket.org/alekseyt/nunicode#markdown-header-sqlite3-extension

Livecode 7 makes it very easy to insert and retrieve Unicode data to/from
an SQlite database but there are some functions within SQlite that don't
work correctly with Unicode, specifically upper(), lower(), COLLATE and X
LIKE Y.

The above sqlite extension makes those function work.  It's a library that
is loadable at runtime.

To load a runtime extension from Livecode:

- use the "extensions" keyword of the revOpendatabase sqliteoptions
parameter

- use the SQLite load_extension() function to load the library.



More information about the use-livecode mailing list