> Ivan Shmakov writes:
> Roger Binns writes:
[…]
>> Consequently if you had a trigger pulling a stunt like this, your
>> code could try to insert a blob and silently (wrongly) end up with a
>> string. SQLite won't even complain if the blob isn't a valid text
>> encoding producing an
> Roger Binns writes:
> On 08/17/2011 09:25 PM, Ivan Shmakov wrote:
>> Somehow, I've assumed that sqlite3_bind_blob () will bind a
>> parameter to a blob.
> It does. There are no affinity rules that will cause otherwise.
> There are some operations that cause blobs to be silently
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 08/17/2011 09:25 PM, Ivan Shmakov wrote:
> Somehow, I've assumed that sqlite3_bind_blob () will bind a
> parameter to a blob.
It does. There are no affinity rules that will cause otherwise.
There are some operations that cause blobs
> Roger Binns writes:
> On 08/16/2011 04:59 PM, Ivan Shmakov wrote:
>> In the sqlite3's .dump command's output, the binary blobs may either
>> be represented as hexadecimal X''-literals, or as text strings.
[…]
> I suggest using typeof on the data you think is blobs to verify what
>
4 matches
Mail list logo