SQLite, Unicode & LC

[Devin Asay]

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

Devin


Devin Asay
Learn to code with LiveCode University
http://university.livecode.com