Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char - FULL CODE

I ran your code with my test file and I get this...which is perfectly correct. Do you get something different? What makes you think the stream is truncated in the database? Also...change SQLITE_STATIC to SQLITE_TRANSIENT...that could be your culprit if you are still seeing truncation. Plus

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Senior Scientist > NG Information Systems > Advanced Analytics Directorate > > > > ____ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Lynton Grice [lynton.gr...@logosworld.com] > Sent: Sund

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char - FULL CODE

Hi Drake, Hi Richard, Hi Paul, Thanks for all your comments, I really appreciate the help. Please see FULL code below. You can literally copy and paste this and compile it with something like: gcc -m64 -Wall -g -I./ -c ./main.c -o ./bigbyte.o gcc -o ./bigbyte ./bigbyte.o -L./ -Wl,-rpath,./

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

gt; bind? If so, that > > > > Michael D. Black > Senior Scientist > NG Information Systems > Advanced Analytics Directorate > > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Lynton Grice [lynton

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

__ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Lynton Grice [lynton.gr...@logosworld.com] Sent: Sunday, April 03, 2011 6:24 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char Hi Paul

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Hi Richard, My apologies on the subject line, I did not mean it to say the function is incorrect, but merely to understand why it is chopping it off I am responding to the other now Lynton On 03/04/2011 13:16, Richard Hipp wrote: > Others have responded with requests for information

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Hi Paul, Yes, I am using fsize as the msg.num_bytes_in.. When I run "SELECT Length(raw_stream_in) FROM test " I get the FULL 13035138 bytes But it I read the "raw_stream_in" and sent it to a file (using ".output result.txt") I only see chars up until the FIRST NUL. Any ideas?

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Others have responded with requests for information needed to help track down the root of this problem. (Thanks!) But in the meantime, let me just assure you that your subject line is absolutely, positively incorrect. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Quoth Lynton Grice , on 2011-04-03 12:37:06 +0200: > There are NULL characters You mean NUL characters. > in the first couple header fields [...] > > I am no C expert but I have the following table defined: > > char *queueTable = "CREATE TABLE [test] ( " >

[sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Hi there, I have a 15MB file I need to read and store in an SQLite database. I have attached a file to show you that there are NULL characters in the first couple header fields and the rest is pure BINARY data. But just incase the image gets stipped off while posting you can imagine the file

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

om] Sent: Sunday, April 03, 2011 5:37 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] sqlite3_bind_blob CHOPS off at first NULL char Hi there, I have a 15MB file I need to read and store in an SQLite database. There are NULL characters in the first couple header fields and the rest is pu

Re: [sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Hi Lynton, What is the value of msg.num_bytes_in? Is it fsize? And what do you get when you SELECT Length(raw_stream_in) FROM test ? Regards, Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] sqlite3_bind_blob CHOPS off at first NULL char

Hi there, I have a 15MB file I need to read and store in an SQLite database. There are NULL characters in the first couple header fields and the rest is pure BINARY data. You can imagine the file looking like: ppphNULNUL3STR.and then all the BINARY data.. I am no C expert but I