[OT] SQLite/Unicode

[Kay C Lan]

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
> 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.
> _______________________________________________
> 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
>