SQLite, Unicode & LC
devin_asay at byu.edu
Wed Apr 9 20:21:02 CEST 2014
On Apr 9, 2014, at 12:07 PM, Peter Haworth <pete at lcsql.com>
> Thanks Devin, I was wondering about that. Will the above method still work
> in 7?
I believe it will still work, but will be deprecated.
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
> On Wed, Apr 9, 2014 at 10:05 AM, Devin Asay <devin_asay at byu.edu> wrote:
>> Kay and Pete,
>> On Apr 9, 2014, at 10:14 AM, Peter Haworth <pete at lcsql.com> wrote:
>>> Hi Kay,
>>> I think I have got this working. Looking at the dictionary entry for
>>> uniencode, there's a user note with the following recommendation:
>>> put unidecode(uniencode(tData,"UTF8)) into tData
>>> Tried that and it fixed the problem, database looks fine now.
>>> The user note credits Devin Assay and Dave Cragg for the solution so
>>> to those folks.
>> Yep, that's the way to do it for now. Once LC 7 hits the streets it will
>> be slightly different (and simpler.)
Office of Digital Humanities
Brigham Young University
More information about the use-livecode