Kay C Lan
lan.kc.macmail at gmail.com
Sun Jul 12 07:12:15 EDT 2015
Very useful. Thanks for posting that.
On Tue, Jul 7, 2015 at 5:01 AM, Peter Haworth <pete at lcsql.com> wrote:
> 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
> 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
> - use the SQLite load_extension() function to load the library.
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode