Hello Martin, it's a db than an user sent me... so I really don't know...
-- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Jun 5, 2009, at 11:31 AM, Martin Engelschalk wrote: > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
