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