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