The MD5Sum column is char[33], the sum is 32 characters long, the C datatype is also char[33] (i.e. one extra character for NULL termination).
I thought the bind text column function stopped at the first NULL character so the column should not have NULL character. Timestamp column is also bigger than timestamp text, but I can select based upon timestamp column. Hemant Shah E-mail: hj...@yahoo.com --- On Mon, 9/27/10, Igor Tandetnik <itandet...@mvps.org> wrote: > From: Igor Tandetnik <itandet...@mvps.org> > Subject: Re: [sqlite] sqlite cannot find the row > To: sqlite-users@sqlite.org > Date: Monday, September 27, 2010, 6:29 PM > Hemant Shah <hj...@yahoo.com> > wrote: > > I ran .dump command to dump the data to a file, and > ran .read command to read it into a different database. Now, > I could do a > > select based upon MD5Sum column. > > > > Next I edited the output file and changed the table > name. I ran .read and loaded the data into new table in > original database. > > Now, I could do a select based upon MD5Sum column. > > > > Any idea what could be wrong? > > Does this statement return any rows on the "bad" database > file: > > select * from find_retransmissions where length(MD5Sum) != > 32; > > My guess is, you managed to insert strings into MD5Sum > column complete with the trailing NUL byte. > -- > Igor Tandetnik > > > _______________________________________________ > 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
