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: [email protected] --- On Mon, 9/27/10, Hemant Shah <[email protected]> wrote: > From: Hemant Shah <[email protected]> > Subject: Re: [sqlite] sqlite cannot find the row > To: "General Discussion of SQLite Database" <[email protected]> > 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: [email protected] > > > --- On Mon, 9/27/10, Igor Tandetnik <[email protected]> > wrote: > > > From: Igor Tandetnik <[email protected]> > > Subject: Re: [sqlite] sqlite cannot find the row > > To: [email protected] > > Date: Monday, September 27, 2010, 10:14 PM > > Hemant Shah <[email protected]> > > 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 > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
