[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:


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

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

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

More information about the Use-livecode mailing list