I will try it tomorrow morning. I do not have access right now.
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, 10:14 PM > Hemant Shah <hj...@yahoo.com> > wrote: > > 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). > > This is largely irrelevant to the issue at hand. > > > I thought the bind text column function stopped at the > first NULL character > > It does, if you pass -1 for the fourth parameter (the > length). It doesn't if you pass an explicit length. SQLite > can happily store text with embedded NUL characters. > > > so the column should not have NULL character. > > Have you tried the query I suggested? Does or does not it > return any rows? You don't need to guess. > -- > 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