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
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...
>
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,
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
Maybe don't use varchar, but text instead when creating the table.
RBS
> 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';
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
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
You can download the db from:
http://www.sqlabs.com/download/test.sqlite
It's only 4KB.
--
Marco Bambini
http://www.sqlabs.com
http://www.creolabs.com/payshield/
On Jun 5, 2009, at 11:04 AM, Marco Bambini wrote:
> Anyone can please explain me why this query:
> SELECT * FROM lo_user WHERE
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
9 matches
Mail list logo
