[OT] SQLite/Unicode

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:
> 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
> 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.
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode

More information about the Use-livecode mailing list