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