can not get data

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

can not get data

lizhuang@whaty.com
hi,Dear development
        I got a problem with sqlite3 in IOS10.2
when I query :
select * from downloadVideo_table where sectionId = '402814a34b823b23014bfc228fe9588c'
but there is nothing.

then I query the length of 'sectionId', it is 32.that is right.
select length(sectionId) from downloadVideo_table where site_code = 'jyzdy'

at last,
I query this:
select * from downloadVideo_table where sectionId like  '402814a34b823b23014bfc228fe9588c%'
or this:
select * from downloadVideo_table where sectionId like  '%402814a34b823b23014bfc228fe9588c'
I saw the data right.
it is so weird.

check the attachment,please.
you can open it with navicat.
Thank you for read it.

Yours sincerely
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: can not get data

Tony Papadimitriou
LIKE is case insensitive, while = is not.

-----Original Message-----
From: [hidden email]

when I query :
select * from downloadVideo_table where sectionId =
'402814a34b823b23014bfc228fe9588c'

then I query the length of 'sectionId', it is 32.that is right.
select length(sectionId) from downloadVideo_table where site_code = 'jyzdy'

at last,
I query this:
select * from downloadVideo_table where sectionId like
'402814a34b823b23014bfc228fe9588c%'
or this:
select * from downloadVideo_table where sectionId like
'%402814a34b823b23014bfc228fe9588c'
I saw the data right.
it is so weird.

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...