Quoting [EMAIL PROTECTED]: > Jim Dodgen <[EMAIL PROTECTED]> wrote: > > I am having a problem with blobs, I seem to insert ok but only get three > (3) > > bytes when I query it back. yes I am setting LongReadLen. any ideas? > > > > thanks > > > > Jim > > > > I'm using sqlite 3.2.7, 1.09 and of the perl module also code and test > results > > are below. > > > > also when I use the command line sqlite3 I also only get 3 characters > back. > > > > > > What do you get back (using the command-line client) when you > ask for LENGTH(x) or QUOTE(x) instead of just the column x? > > -- > D. Richard Hipp <[EMAIL PROTECTED]>
sqlite> select length(val) from foo; 3 sqlite> select quote(val) from foo; 'MZP' strange, reports a length of 3 but the database is > the size of the file i put into the blob. other than the record in foo the database is fresh and empty. > >
