Re: [sqlite] Encoding question

On 2/1/15, Peter Haworth wrote: > I'm new to the unicode world so this question may not make sense. > > The "PRAGMA encoding" statement tells me the encoding of a database. Can I > rely on all data in the database having that encoding? For example, if the > encoding is UTF8 and a row is inserted c

Re: [sqlite] Encoding question

On Mon, Feb 2, 2015 at 12:49 AM, RSmith wrote: > guarantee that /IF/ you put valid UTF-8 data in there, it will be handled > and returned correctly). > For a given definition of "correct." A relatively common topic on this list is the handling of locale-specific collations (a topic i'm not quali

Re: [sqlite] Encoding question

On 2015/02/02 01:12, Peter Haworth wrote: I'm new to the unicode world so this question may not make sense. The "PRAGMA encoding" statement tells me the encoding of a database. Can I rely on all data in the database having that encoding? For example, if the encoding is UTF8 and a row is inserte

[sqlite] Encoding question

I'm new to the unicode world so this question may not make sense. The "PRAGMA encoding" statement tells me the encoding of a database. Can I rely on all data in the database having that encoding? For example, if the encoding is UTF8 and a row is inserted containing UTF16 encoded data, will it stil

[sqlite] Possible to get list of terms in the Full Text Index?

Hi, Is it at all possible to get a listing of all terms in the Full Text Index and which rowid's they were found in? E.g. row1: one, two, three, three row2: one row3: three Listing: one [1,2] two [1] three [1,3] And with a score count would be even better.. Is such information available?

Re: [sqlite] System.Data.SQLite for Pocket PC & RTREE

Hi I have investigated this problem further and it appears that RTree is definitely enabled, most queries work fine, but a query to the index fails. I have tried a straight query to the index SELECT * FROM idxNetwork WHERE ROWID = 1, which fails crashing the app at command.ExecuteReader()

Re: [sqlite] Custom functions, variable parameters, and SELECT triggers

Thank you both for the thoughtful responses. Comments: Re: NEW.* -- Thanks Igor for pointing out that my assumptions were totally off base. Assumptions are tricky things! Re: "Why can't the trigger call myFunc(new.colA, new.colB)" -- that would definitely work, but I'd like to make the trigger