[Chicken-users] Inserting Binary Data with sql-de-lite

[Andy Bennett]

Hi,

I'm using a parameterized statement to insert binary data into 
sql-de-lite (0.6.6) on CHICKEN 4.10rc1.

When I call sql-de-lite's exec procedure I get:

-----
Error: (##sys#make-c-string) cannot represent string with NUL bytes as 
C string: "��\x00...

...

        Call history:

        sql-de-lite.scm:459: lru-cache#lru-cache-capacity
        sql-de-lite.scm:188: ##sys#block-set!
        sql-de-lite.scm:461: lru-cache#lru-cache-set!
        sql-de-lite.scm:175: ##sys#block-set!
        sql-de-lite.scm:567: bind-parameter-count
        sql-de-lite.scm:581: keyword?
        sql-de-lite.scm:583: bind
        sql-de-lite.scm:594: %bind-int
        sql-de-lite.scm:605: bind-parameter-count
        sqlite3-api.scm:155: ##sys#make-c-string
        sql-de-lite.scm:584: loop
        sql-de-lite.scm:581: keyword?
        sql-de-lite.scm:583: bind
        sql-de-lite.scm:594: %bind-int
        sql-de-lite.scm:605: bind-parameter-count
        sqlite3-api.scm:155: ##sys#make-c-string                <--
-----


What's the recommended way to do or fix this? In the CHICKEN 4.7 days I 
have taken binary data *out* of SQLite but I've not done it since the 
NUL-string problems were addressed.

The data gets into CHICKEN by reading it from a port using http-client.


Thanks for your help.

Sorry I'm light on details: I can send more sensible stuff on request.



--
address@hidden
http://www.ashurst.eu.org/
http://www.gonumber.com/andyjpb
0x7EBA75FF