SQLite, Unicode & LC
devin_asay at byu.edu
Wed Apr 9 19:05:43 CEST 2014
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 thanks
> 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.)
Learn to code with LiveCode University
More information about the use-livecode