iOS sqlite3儲存數組NSArray

iOS sqlite3儲存數組NSArray

四個注意點：1.建立表時，聲明欄位類型為二進位 blobNSString *INEditorTableName = @"create table In_Editor(picUrls blob not null)";2.插入sql語句，把NSArray轉換為NSData類型NSData *dataImageUrls = [NSKeyedArchiver archivedDataWithRootObject:model.imageUrls];3.不能用 [NSString stringWithFormat: @"sql"];[_db executeUpdate: @"insert into In_Editor ( picUrls) values (?);",dataImageUrls];4.讀取資料: NSArray *imageArr = [NSKeyedUnarchiver unarchiveObjectWithData:picUrls]// 如果不注意，上面幾點，可能會出現下面錯誤：* Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[__NSCFData objectForKey:]: unrecognized selector sent to instance 0x6b46c80'

 

 

註：NSArray 與 NSData的相互轉換 二進位將NSArray轉化為NSData類型 ：NSData *data = [NSKeyedArchiver archivedDataWithRootObject:Array];將NSData轉化為NSArray類型 ：NSArray *array = [NSKeyedUnarchiver unarchiveObjectWithData:data];Integer:值是signedinteger類型，大小可以是1,2,3,4,6,8bytesREAL:浮點類型TEXT:以UTF-8,UTF-16BEorUTF-16LE編碼儲存的字元類型BLOB:位元據