Your field value is a blob, so you have to use a cast like you did to find the row, or use a blob literal: SELECT * FROM lo_user WHERE lo_name=X'61646d696e';
Marco Bambini wrote: > I just posted the db on my website... there is one row and there > aren't invisible characters. > > Please note that the following query returns the exact row: > SELECT * FROM lo_user WHERE CAST(lo_name AS TEXT)='admin'; > but I really don't have an explanation... > > -- > Marco Bambini > http://www.sqlabs.com > http://www.creolabs.com/payshield/ > > > > > > > On Jun 5, 2009, at 11:10 AM, Martin Engelschalk wrote: > > >> Hi, >> >> attachments do not make it through the list. >> There is no row with the value 'admin' in the field 'lo_name' in your >> table. Did you check that there are no blank spaces or other invisible >> characters? >> >> Martin >> >> Marco Bambini wrote: >> >>> Anyone can please explain me why this query: >>> SELECT * FROM lo_user WHERE lo_name='admin'; >>> returns 0 rows in this db? >>> >>> >>> >>> Thanks. >>> -- >>> Marco Bambini >>> http://www.sqlabs.com >>> http://www.creolabs.com/payshield/ >>> >>> >>> >>> >>> >>> >>> ------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> 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 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users