SQLite, Unicode & LC

Peter, Glad I could get you over the first hurdle. Seems though we might be hitting the 2nd hurdle at the same time. I'm reading a file into LC and it contains this word: Cabañesas --the 5th char being numToChar(150) on Mac it ends up in a variable exactly the same. I then feed it into a SQLi

Re: SQLite, Unicode & LC

On Wed, Apr 9, 2014 at 7:07 AM, Peter Haworth wrote: I am however, whether I like it or not, having to get into the weird world > of Unicode (I think). Some of the artist names and CD names in my iTunes > library have accented characters which end up in the tab delimited file as > . The corrupte

Re: SQLite, Unicode & LC

Just talking out my derrier here, but can’t you simply uniencode all your data that contains odd characters, then store them as a blob in your database? Unidecode them when your read them out of the database? Bob On Apr 8, 2014, at 18:58 , Kay C Lan wrote: > On Wed, Apr 9, 2014 at 7:07 AM, P

Re: SQLite, Unicode & LC

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 Dav

Re: SQLite, Unicode & LC

Kay and Pete, On Apr 9, 2014, at 10:14 AM, Peter Haworth 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 fixe

Re: SQLite, Unicode & LC

Thanks Devin, I was wondering about that. Will the above method still work in 7? Pete lcSQL Software Home of lcStackBrowser and SQLiteAdmin On Wed, Apr 9, 2014 at 10:05 AM, Devin Asay wrot

Re: SQLite, Unicode & LC

On Apr 9, 2014, at 12:07 PM, Peter Haworth 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 > Home of lcStackBrowser

Re: SQLite, Unicode & LC

On Wed, Apr 9, 2014 at 11:21 AM, Devin Asay 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. > Hi Devin, Yes, just saw that in the 7.0 release notes. I also see that there is a new form o

Re: SQLite, Unicode & LC

On Apr 9, 2014, at 1:07 PM, Peter Haworth wrote: > On Wed, Apr 9, 2014 at 11:21 AM, Devin Asay 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. >> > > Hi Devin, > Yes, just saw

Re: SQLite, Unicode & LC

On Thu, Apr 10, 2014 at 1:05 AM, Devin Asay wrote: > > Yep, that's the way to do it for now. > > OK, well that solved my current problem but isn't a solution. Pete said: 1) Exports from iTunes and gets a word like eÜjûzëiÇoò [hope it displays with all the accents] with all the accented chars as

Re: SQLite, Unicode & LC

A few comments below. On Wed, Apr 9, 2014 at 8:28 PM, Kay C Lan wrote: > Pete said: > > 1) Exports from iTunes and gets a word like eÜjûzëiÇoò [hope it displays > with all the accents] with all the accented chars as garbage. > That's correct when I used Textedit with its default character encod

Re: SQLite, Unicode & LC

On Fri, Apr 11, 2014 at 12:46 AM, Peter Haworth wrote: > Do you know what version of the SQLite library your admin tool is using? > I'm wondering if there's some incompatibility in how UTF8 is handled in > different versions of the SQLite library. > > That's my assumption. Valentina Studio 5.5.