SQLite, Unicode & LC

[Devin Asay]

On Apr 9, 2014, at 12:07 PM, Peter Haworth <pete at lcsql.com>
 wrote:

> 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.
> 
> Pete
> 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
>> 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 Asay
Office of Digital Humanities
Brigham Young University