If I use "length(MD5Sum) != 32" I get nothing. If I use "length(MD5Sum) == 32" I gat all rows. The length of the column should be 32.
Hemant Shah E-mail: hj...@yahoo.com --- On Mon, 9/27/10, Hemant Shah <hj...@yahoo.com> wrote: > From: Hemant Shah <hj...@yahoo.com> > Subject: Re: [sqlite] sqlite cannot find the row > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Date: Monday, September 27, 2010, 10:23 PM > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users