[sqlite] Why are strings in hexadecimal notation always blobs?

hex quotes no matter what data is inside. But this is bad for a GUI Frontend i've written which is displaying data differently if 'sqlite3_column_type' returns 4. -- Best regards, Lothar Scholz mailto:[EMAIL

Re: [sqlite] Re: Why are strings in hexadecimal notation always blobs?

Hello Igor, Friday, January 18, 2008, 8:09:02 PM, you wrote: IT> Lothar Scholz IT> wrote: >> it seems that "Lothar" is stored as a TEXT value but when i store >> X'4C6F74686172' it is a BLOB. >> What is the reason for it? IT> Same reason 1 is an intege

[sqlite] Is there a difference between NULL und zero byte length BLOB/TEXT?

Hello, The last question for today: Is there a difference between NULL und zero byte length BLOB/TEXT? Need this information for my SQLite GUI Frontend. -- Best regards, Lothar Scholz mailto:[EMAIL PROTECTED

Re: [sqlite] Re: Re: Why are strings in hexadecimal notation always blobs?

doing it when it assumes everything is a string and (since version 7.X )we got the cached integer or double values. But well i can code around this like usual but i will bring up the topic again if there is a discussion about a 4.0 release. -- Best regards, Lothar Scholz

[sqlite] What is the precise definition of an identifier?

productions. -- Best regards, Lothar Scholz mailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: What is the precise definition of an identifier?

te string literals. Correct? -- Best regards, Lothar Scholzmailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] No way to dump a database with large BLOB's ?

Hello, Dumping a database with images i run into the 1 million byte per SQL statement limit. I thought that the usual way to backup a database is the sqlite.exe and dump and eval method. Shouldn't this limit be dynamic instead of hard wired into a compile constant? -- Best regards, Lothar

[sqlite] Why does the FAQ example use 2 copies for adding/deleting a column

not exist when the FAQ was created? -- Best regards, Lothar Scholz mailto:[EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Re: [unclassified] [sqlite] Re: Why does the FAQ example use 2 copies for adding/deleting a column

Hello Igor, Tuesday, January 29, 2008, 9:06:56 AM, you wrote: IT> Lothar Scholz IT> wrote: >> This is copying the whole table twice. Is there any reason why it >> shouldn't be: >> >> BEGIN TRANSACTION; >> CREATE TEMPORARY TABLE t1_backup(a,b); >>

Re: [sqlite] SQLite database on a certain high-performance "SSD"

Hello Mark, Tuesday, September 22, 2009, 3:53:48 AM, you wrote: M> I've currently got a loaner high-performance flash-based "SSD" (let's M> just say it doesn't connect to any disk controllers) that I'm testing M> for performance. I've run my application against it, and I believe that M> I

[sqlite] Is there an optimization for "IS NULL" operator in a SELECT query ?

It is driving me crazy. I'm working on a web spider where a table holds the downloaded webpage. It seems that a select "SELECT count(*) WHERE NOT text IS NULL" requires that the complete text column is loaded. With a stored LOB this results in crazy performance. Is this optimized in later

Re: [sqlite] Is there an optimization for "IS NULL" operator in a SELECT query ?

o? I never thought about this and always considered it syntax-sugar for the count function. And it seems i'm right, no change either. So it's maybe time to say byebye to SQLite and move on to a real database system. -- Best regards, Lothar Scholzmailto: