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,
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
"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
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
4 matches
Mail list logo