[sqlite] sqlite3_exec statement count including create/drop?

Is there a C API way to get a total count or notification as each statement is prepared by sqlite_prepare_v2 within sqlite3_exec? The sqlite3_exec callback interface is silent with respect to CREATE and DROP statements. Presumably I could copy and paste the entire body of sqlite3_exec into my

Re: [sqlite] 3.18, 3.19 branches

On 6/18/17, jcheval...@gmx.net wrote: > Why are commits being done atop the 3.18 branch instead of 3.19? Is it > because a breaking change in 3.19? Will 3.18 eventually turn into 3.20? Or > is 3.18 only of interest for selected developments? Some project might consider 3.19.3

Re: [sqlite] How to search for fields with accents in UTF-8 data?

Dear CC: I use Spanish language, with letters with accents. When I try to import from a .csv the data obtained in the table was "rare" and I have to implement some routines to convert "What the program read to the letter I want to write", and I solve the problem. I think in a prehistory way.

Re: [sqlite] Questions about SQLite Encryption Extension (SEE)

Jens Alfke writes: >> On Jun 17, 2017, at 7:02 AM, Yuriy M. Kaminskiy wrote: >> >> *) don't appear to be able to keep key in system-provided secure >> device/enclave; > > In their defense, I think this is out-of-scope for a cross-platform db > encryption

[sqlite] 3.18, 3.19 branches

Why are commits being done atop the 3.18 branch instead of 3.19? Is it because a breaking change in 3.19? Will 3.18 eventually turn into 3.20? Or is 3.18 only of interest for selected developments? ___ sqlite-users mailing list

Re: [sqlite] How to search for fields with accents in UTF-8 data?

CC wrote: > I imported a CSV file where data are encoded in UTF-8. > > Some of the characters (like Î) are not available in the ASCII table, so I > can't use the CLI sqlite3.exe to search. The latest version of sqlite3.exe might work. Anyway, to check that whatever tool you're using uses

[sqlite] How to search for fields with accents in UTF-8 data?

Hello I imported a CSV file where data are encoded in UTF-8. Some of the characters (like Î) are not available in the ASCII table, so I can't use the CLI sqlite3.exe to search. As an alternative, I tried SQLite Studio, but it fails: ;Returns no record SELECT COUNT(*) FROM MyTable WHERE