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
