Hi Michael, When I mean't the ".output" I was meaning when I am using the SQLite command line tool, I type in ".output result.txt" and then type "select raw_stream_in from queue;" to stream that result to file.
The result file only contains character up until the first NUL. Also, I know it is an image file (binary) I am just in the habit on having .txt extensions when doing testing as all I care about is the raw data....in fact I should just leave off the extension entirely. I have submitted my full code in my previous message, thanks....please let me know if you see anything? I ran your test below, on my Linux machine and it still has the same issue, meaning after the INSERT into SQLite I do a ".output result.txt" and it still only shows "AB" in your example.... Here is the result of running od -xa result.txt 0000000 4241 000a A B nl 0000003 I must be doing something fundamentally wrong.....;-( Thanks for the help so far, I really appreciate it..... Lynton On 03/04/2011 13:44, Black, Michael (IS) wrote: > How are you trying to view the ouitput.result.txt (and I"ll note that it'sNOT > a text file...it's an image according to what you said.). What's the size of > the file. > > And you should be able to post a COMPLETE example to show your testing. What > you say you want to do has been done by many before so you're doing something > wrong but you aren't showing it. > > Create a small test file using this: > > #include<stdio.h> > main() > { > FILE *fp=fopen("test.dat","w"); > char buf[10]; > int i; > for(i=0;i<10;++i) buf[i]=i+'A'; > buf[2] = 0; > fwrite(buf,1,sizeof(buf),fp); > fclose(fp); > } > > If you're on Unix (or have Unix utils installed on Windows) you should see > this: > ls -l test.dat > -rw-r--r-- 1 mblack users 10 Apr 3 07:41 test.dat > od -xa test.dat > 0000000 4241 4400 4645 4847 4a49 > A B nul D E F G H I J > 0000012 > more test.dat > AB > > Note the "more" stop at the first NUL character like it should. > > Then...use this file to test your stream, show us the resulting file with "od > -xa" and show us your code. > > > 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.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, > > 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? > > Thanks > > Lynton > > > > On 03/04/2011 12:52, Paul van Helden wrote: >> 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 >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users