Andy, What if you convert the string to a blob before passing it in? Jim > On Jun 22, 2015, at 12:16, Andy Bennett <andy...@ashurst.eu.org> wrote: > > 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. > > > > -- > andy...@ashurst.eu.org > http://www.ashurst.eu.org/ > http://www.gonumber.com/andyjpb > 0x7EBA75FF > > _______________________________________________ > Chicken-users mailing list > Chicken-users@nongnu.org > https://lists.nongnu.org/mailman/listinfo/chicken-users
_______________________________________________ Chicken-users mailing list Chicken-users@nongnu.org https://lists.nongnu.org/mailman/listinfo/chicken-users