Re: [sqlite] BLOB Literals and NULL

2009-05-22 Thread John Machin
On 23/05/2009 10:56 AM, Greg and Tracy Hill wrote: > Is it possible to use the BLOB literal sytax X'ABCD' with encoded NULLs? > > For example: > > INSERT INTO mytable VALUES (X'BADF00D0') I see no NULL here, encoded or otherwise. I don't even see an ASCII NUL here; NUL is character terminology,

Re: [sqlite] BLOB Literals and NULL

2009-05-22 Thread Simon Slavin
On 23 May 2009, at 1:56am, Greg and Tracy Hill wrote: > Is it possible to use the BLOB literal sytax X'ABCD' with encoded > NULLs? My understanding is that you can store anything you want as a BLOB. But that when you read that value back again, you'll get a BLOB back. You can't write a

Re: [sqlite] BLOB Literals and NULL

2009-05-22 Thread Igor Tandetnik
"Greg and Tracy Hill" wrote in message news:bay112-w186a5fad8703c04c8f30c0dd...@phx.gbl > Is it possible to use the BLOB literal sytax X'ABCD' with encoded > NULLs? Yes. > For example: > > INSERT INTO mytable VALUES (X'BADF00D0') > > When I do this, the length of the data is

[sqlite] BLOB Literals and NULL

2009-05-22 Thread Greg and Tracy Hill
Is it possible to use the BLOB literal sytax X'ABCD' with encoded NULLs? For example: INSERT INTO mytable VALUES (X'BADF00D0') When I do this, the length of the data is 2 instead of the expected 4. I know I could use prepared statements but the library I am using doesn't expose them. Any