[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