[sqlite] Storing unicode

Hello all, Can you please tell me how to store UNICODE in SQLite v3? I'm using the sqlite3_mprintf() functions with %q, but it doesn't handle UNICODE correctly - I pass in a CString with a UNICODE value, but on the output of this function I get an incorrect string. The program is of course compil

Re: Re: [sqlite] C callback that returns numeric data without conversion from text?

Great, that fits the bill perfectly, thanks! I know you mentioned the code is incomplete but the usage instructions don't match the executable's behavior: the third command line argument (the SQL command, or argv[2]) isn't used by the code. The interactive mode works great though, and demonstrat

[sqlite] Compilation warning

Hi, I am using Sun Workshop 6.2 compiler on Solaris 8 and version 3 of SQLite. I am getting a compiler warning and was wondering of anyone could help me solve it Warning (Anachronism): Formal argument 5 of type extern "C" void(*)(void *) in call to sqlite3_bind_text(sqlite3_stmt*,

Re: [sqlite] re: ANN: SQLiteDB, a COM wrapper around sqlite has been released

Hi Fred, The SQLite code is in the DLL (you do not need to install the SQLite3.02 dll). This wrapper is excellent! As a third party reviewer, I find it to be the best one to date! Sincerely, Ed Porter At 11:42 AM 7/27/04 +0200, Frederic Faure wrote: >George Ionescu >> I have just released SQLi

Re: [sqlite] concurrent insert?

Daniel Franke wrote: The statement: INSERT INTO haploshare SELECT id1, id2, locus, CASE WHEN p1 == 0 OR p2 == 0 THEN NULL WHEN p1 != p2 THEN 0 ELSE -1 END, CASE WHEN p1 == 0 OR m2 == 0 THEN NULL WHEN p1 != m2 THEN 0 ELSE -1 END, CASE WHEN m1 == 0 OR p2 == 0 THEN NULL WHEN m1 != p2 THEN 0 E

Re: [sqlite] concurrent insert?

> > I'm creating a table by inserting rows from a select statement. Given > > enough memory this takes a few hours for small datasets and ages for > > larger ones. > Guillaume FOUGNIES: > try a 'PRAGMA synchronous=OFF;' before executing your statement. Yes, this is already implemented. In additi

Re: Re: [sqlite] C callback that returns numeric data without conversion from text?

On Mon, Jul 26, 2004 at 08:05:17PM -0700, Al Danial wrote: > Thanks for the clarification. I'll need to study the docs on the three > part method and slowly figure it out. A working example sure would > be nice! -- Al > > On Mon, 26 Jul 2004 11:21:08 +0100 (BST), Christian Smith >

[sqlite] collation sequence

would it be possible to add a COLLATE keyword at the TABLE level, also, so that, if the following is executed : CREATE TABLE bla(...) COLLATE mySequence then this sequence is the default for this table, when no specific sequence is defined ? or, if this is not possible, is it possible to overrid

Re: [sqlite] concurrent insert?

Daniel Franke wrote: Hi everyone, is there a way to employ more than one process (or processors) in a single update statement? No. SQLite is I/O bound so it won't help even if you could. I'm creating a table by inserting rows from a select statement. Given enough memory this takes a few hours fo

Re: [sqlite] concurrent insert?

On Tue, 27 Jul 2004, Daniel Franke wrote: > >Hi everyone, > >is there a way to employ more than one process (or processors) in a single >update statement? > >I'm creating a table by inserting rows from a select statement. Given enough >memory this takes a few hours for small datasets and ages for

Re: [sqlite] concurrent insert?

Hello, try a 'PRAGMA synchronous=OFF;' before executing your statement. Bye Tue, Jul 27, 2004 at 10:51:58AM +0200: Daniel Franke wrote: > > Hi everyone, > > is there a way to employ more than one process (or processors) in a single > update statement? > > I'm creating a table by inserting ro

[sqlite] re: ANN: SQLiteDB, a COM wrapper around sqlite has been released

George Ionescu >> I have just released SQLiteDB, a COM wrapper around sqlite written in ATL. Is the SQLite source compiled in the DLL, or do we need to deploy the two DLL's? Thx Fred.

[sqlite] sqlite3x removed pragmas

> > DEFAULT_SYNCHRONOUS no longer exists. The default setting for > > synchronous is FULL. If you want something different, you have > > to change it every time you open a new connection. > > ok > > > SHOW_DATATYPES no longer exists. and is not needed ? > > > The following pragmas are scheduled

[sqlite] concurrent insert?

Hi everyone, is there a way to employ more than one process (or processors) in a single update statement? I'm creating a table by inserting rows from a select statement. Given enough memory this takes a few hours for small datasets and ages for larger ones. There's a SMP-system next door, 64

Re: [sqlite] Versions 2.8.15 and 3.0.3 available

Doug Currie, dando pulos de alegria, escreveu : I believe I tried that (exactly because I understood that from the docs) but found it didn't work for empty tables. Please try it again; I just tried it with an sqlite3 I built on June 24, and it is working... Thanks, I will. Probably some bug in my f