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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to