Hi Marco, How do you insert this data into your database? I opened your database with an old version of SQLiteSpy, which uses an even older version of sqlite. It showed the value as a blob.
Martin Marco Bambini wrote: > I understand that the issue could be caused by the wrong datatype... > but what is strange is that the same db and the same query worked fine > with sqlite 3.4.2 and the behavior changed with sqlite 3.6.x > > -- > Marco Bambini > http://www.sqlabs.com > http://www.creolabs.com/payshield/ > > > > > > > On Jun 5, 2009, at 11:17 AM, Martin Engelschalk wrote: > > >> 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 >> > > _______________________________________________ > 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
