Re: [sqlite] Trouble importing hex encoded blob

I peeked at the source code real quick and it looks like it just converts the contents of the file into a bunch of SQL that is essentially opening a transaction and doing an insert for each row followed by a commit. This suggest I just need to format it differently so I'll play around with that

Re: [sqlite] Trouble importing hex encoded blob

On Fri, May 11, 2012 at 10:13 PM, Joshua Shanks wrote: > I set the separator to tab and then in the file it is > > X'somevalue'\tX'someothervalue'\n > X'morestuff'\tX'evenmore'\n > > but with real hex values > > According to the documentation > That document you quote is

Re: [sqlite] Trouble importing hex encoded blob

I set the separator to tab and then in the file it is X'somevalue'\tX'someothervalue'\n X'morestuff'\tX'evenmore'\n but with real hex values According to the documentation BLOB literals are string literals containing hexadecimal data and preceded by a single "x" or "X" character. For example:

Re: [sqlite] Trouble importing hex encoded blob

On 12 May 2012, at 2:01am, Joshua Shanks wrote: > But when I try to use the .import method the values get imported as > the string "X'" instead of the hex blob value and don't get pulled > out correctly. .import is for .csv files. What are you putting in the .csv file

[sqlite] Trouble importing hex encoded blob

I've tried searching for awhile and haven't had any luck. I'm able to store and retrieve blob data using inserts and the hex encoded literals like this INSERT INTO rolled (roll1, roll2) VALUES (X'0001063500',X'00'); But when I try to use the .import method the values get

Re: [sqlite] Getting rowid for last returned row

On 11/05/2012 19:03, Igor Tandetnik wrote: On 5/11/2012 10:36 AM, Scott Ferrett wrote: On 11/05/2012 16:00, Igor Tandetnik wrote: A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid of which row of which table do you

Re: [sqlite] Two-line patch to fix memory leak

Oh darn. If the leak is not obvious to you, and if my patch would cause an undesirable side effect, then the leak may somehow be the fault of our code. I'll have to dig into this a bit further. Sending you our whole tree would be somewhat less than constructive. Maybe I can narrow down to a

Re: [sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

On 11-05-2012 19:47, Richard Hipp wrote: > On Fri, May 11, 2012 at 1:25 PM, Luuk wrote: > >> On 11-05-2012 19:11, Richard Hipp wrote: >>> On Fri, May 11, 2012 at 12:20 PM, Frank Chang >> wrote: >>> Good Afternoon, Is it possible to

Re: [sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

The windoze console defaults to the OEM codepage. Change the console codepage before running sqlite3.exe or change the system default. chcp 65001 see http://superuser.com/questions/269818/change-default-code-page-of-windows-console-to-utf-8 this applied the same on all versions of

Re: [sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

On 11 May 2012, at 6:47pm, Richard Hipp wrote: > Your work-around is to use some flavor of Unix or to set your windows box > to use the unicode 65001 codepage. I no longer use Windows a lot, but I delighted in setting everything to use the Unicode codepage as soon as it was

Re: [sqlite] Two-line patch to fix memory leak

On 05/11/2012 11:28 PM, Eric Sink wrote: In sqlite3Fts3Matchinfo(): Near the end of the function, I added two lines: if( rc!=SQLITE_OK ){ sqlite3_result_error_code(pContext, rc); }else{ int n = pCsr->nMatchinfo * sizeof(u32); sqlite3_result_blob(pContext, pCsr->aMatchinfo, n,

Re: [sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

On Fri, May 11, 2012 at 1:25 PM, Luuk wrote: > On 11-05-2012 19:11, Richard Hipp wrote: > > On Fri, May 11, 2012 at 12:20 PM, Frank Chang >wrote: > > > >> > >> Good Afternoon, Is it possible to inserted European accented > >> strings(UTF-8/UTF-16)

[sqlite] Source Error in EXPLAIN PLAN (for busted compilers)

SQLITE_PRIVATE void sqlite3ExplainBegin(Vdbe *pVdbe){ if( pVdbe ){ sqlite3BeginBenignMalloc(); Explain *p = sqlite3_malloc( sizeof(Explain) ); if( p ){ memset(p, 0, sizeof(*p)); p->pVdbe = pVdbe; sqlite3_free(pVdbe->pExplain); pVdbe->pExplain = p;

Re: [sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

On 11-05-2012 19:11, Richard Hipp wrote: > On Fri, May 11, 2012 at 12:20 PM, Frank Chang > wrote: > >> >> Good Afternoon, Is it possible to inserted European accented >> strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE? If so, could you >> please show us a brief

Re: [sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

On Fri, May 11, 2012 at 12:20 PM, Frank Chang wrote: > > Good Afternoon, Is it possible to inserted European accented > strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE? If so, could you > please show us a brief example. Best Regards Frank. > INSERT INTO user(name)

Re: [sqlite] Getting rowid for last returned row

On 5/11/2012 10:36 AM, Scott Ferrett wrote: On 11/05/2012 16:00, Igor Tandetnik wrote: A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid of which row of which table do you hope to obtain? All of them, including

Re: [sqlite] Getting rowid for last returned row

Simon Slavin wrote: > On 11 May 2012, at 3:36pm, Scott Ferrett > wrote: > >> If this is not possible, I can restrict this bit of code to only work on >> UPDATE statements. But that still leaves me with the problem of needing >> the rowid of the row being updated. >

[sqlite] Two-line patch to fix memory leak

In sqlite3Fts3Matchinfo(): Near the end of the function, I added two lines: if( rc!=SQLITE_OK ){ sqlite3_result_error_code(pContext, rc); }else{ int n = pCsr->nMatchinfo * sizeof(u32); sqlite3_result_blob(pContext, pCsr->aMatchinfo, n, SQLITE_TRANSIENT); ADDED:

[sqlite] Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE?

Good Afternoon, Is it possible to inserted European accented strings(UTF-8/UTF-16) into SQLITE using SQLITE3.EXE? If so, could you please show us a brief example. Best Regards Frank. ___ sqlite-users

Re: [sqlite] Getting rowid for last returned row

On 11 May 2012, at 3:36pm, Scott Ferrett wrote: > If this is not possible, I can restrict this bit of code to only work on > UPDATE statements. But that still leaves me with the problem of needing the > rowid of the row being updated. The only supplied function

Re: [sqlite] Getting rowid for last returned row

On 11/05/2012 16:00, Igor Tandetnik wrote: Scott Ferrett wrote: Is there any way that I can get the row id after the call to sqlite3_step A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid

Re: [sqlite] Getting rowid for last returned row

Scott Ferrett wrote: > Is there any way > that I can get the row id after the call to sqlite3_step A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid of which row of which table do you hope

[sqlite] Getting rowid for last returned row

I am writing a library that other programmers will use to access SQLite tables. They will send SELECT statements that I have no control over. As such I cannot force the _ROWID_ into the SELECT statement. I need the rowid to use with the sqlite3_blob_open function. Is there any way that I

Re: [sqlite] sqlite3_analyzer code download?

On May 11, 2012, at 3:19 PM, Petite Abeille wrote: > I'm using the amalgamation (sqlite-autoconf-3071100.tar.gz). Should I use > something else? Never mind :) sqlite-src-3071100.zip is more appropriate for that thanks :D Thanks. ___ sqlite-users

Re: [sqlite] sqlite3_analyzer code download?

On Fri, May 11, 2012 at 9:19 AM, Petite Abeille wrote: > > On May 11, 2012, at 3:09 PM, Richard Hipp wrote: > > > It's in the main source tree. > > Aha! Thanks :) > > > > > ./configure; make sqlite3_analyzer > > $ uname -a > SunOS imap4lua 5.11 snv_151a i86pc i386 i86pc

Re: [sqlite] sqlite3_analyzer code download?

On May 11, 2012, at 3:09 PM, Richard Hipp wrote: > It's in the main source tree. Aha! Thanks :) > > ./configure; make sqlite3_analyzer $ uname -a SunOS imap4lua 5.11 snv_151a i86pc i386 i86pc $ cd sqlite-autoconf-3071100 $ configure ... $ make sqlite3_analyzer make: Fatal error: Don't

Re: [sqlite] sqlite3_analyzer code download?

On Fri, May 11, 2012 at 8:52 AM, Petite Abeille wrote: > Hello, > > [apologies if I overlooked something obvious, but my google-fu is weak > today] > > Where does one find the sqlite3_analyzer code for download? > > SQLite's download page sports various precompiled

[sqlite] sqlite3_analyzer code download?

Hello, [apologies if I overlooked something obvious, but my google-fu is weak today] Where does one find the sqlite3_analyzer code for download? SQLite's download page sports various precompiled binaries for Linux, Mac OS X, etc, but I cannot spot any link to the source code. Did I miss

Re: [sqlite] intial database creation

I was thinking a bit on your question...let's make some terminology clear. Database file -- a user file on your hard disk that may contain tables Table -- a user table entry which may contain records Records -- a specific user data record in a table containing fields of user data #1 Create "a

Re: [sqlite] run sql file

On 11 May 2012, at 10:25am, YAN HONG YE wrote: > INSERT INTO "t" VALUES(5,'7/1/2011'); > > DELETE FROM t WHERE rowid NOT IN ( > SELECT rowid FROM >( SELECT rowid, num, date FROM t ) CROSS JOIN >( SELECT num min_num, min( date ) min_date FROM t GROUP BY num ) ON >

[sqlite] run sql file

I have a database {TABLE t( num integer, date text );} file, and a bbb.sql file content: INSERT INTO "t" VALUES(1,'1/1/2011'); INSERT INTO "t" VALUES(2,'1/1/2011'); INSERT INTO "t" VALUES(2,'2/1/2011'); INSERT INTO "t" VALUES(3,'1/1/2011'); INSERT INTO "t" VALUES(3,'2/1/2011'); INSERT INTO "t"

[sqlite] FULL OUTER JOIN

http://www.sqlite.org/omitted.html lists what's not supported and "those features near the top of the list are likely to be added in the near future". The list has been unchanged for a few years now, and RIGHT and FULL OUTER JOIN are on the top of the list. I wonder, is it still likely that

Re: [sqlite] Command history not working in sqlite3 tool for MAC OS

Yes, I installed the latest version myself. > Date: Fri, 11 May 2012 07:46:16 +0100 > From: amit.k.chaudh...@gmail.com > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Command history not working in sqlite3 tool for MAC OS > > My Mac is running system provided sqlite3 (3.6.12) and up arrow