FMDB存储字典或数组时会变成字符串存入sqlite里,但如果不将其转换成json格式存储,你查询获取数据时就会获取无法转换成字典或数组的字符串。
转换JSON存储:
NSArray *picArr = (NSArray *)dic[@"pic"];
NSError *err = nil;
NSData *jsonData = [NSJSONSerializationdataWithJSONObject:picArr options:NSJSONWritingPrettyPrintederror:&err];
NSString *jsonStr = [[NSStringalloc] initWithData:jsonDataencoding:NSUTF8StringEncoding];
FMResultSet *set = [app.dbexecuteQuery:@"SELECT * FROM CACHE"];
while ([set next]) {
NSString * jsonStr=[set stringForColumn:@"data"];
NSData *data=[jsonStr dataUsingEncoding:NSUTF8StringEncoding];
NSArray *array=[NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingAllowFragments error:nil];
}