Re: [sqlite] can not get data

2017-04-16 Thread Tony Papadimitriou
LIKE is case insensitive, while = is not. -Original Message- From: lizhu...@whaty.com 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 d

[sqlite] can not get data

2017-04-16 Thread lizhu...@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 downloadV