my UITableView have serious memory leak problem only when the NSString is NOT encoding with NSASCIIStringEncoding.
- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath {
static NSString *CellIdentifier = @"cell";
UILabel *textLabel1;
UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:CellIdentifier];
if (cell == nil) {
cell = [[[UITableViewCell alloc] initWithStyle:UITableViewCellStyleDefault reuseIdentifier:CellIdentifier] autorelease];
textLabel1 = [[UILabel alloc] initWithFrame:CGRectMake(105, 6, 192, 22)];
textLabel1.tag = 1;
textLabel1.textColor = [UIColor whiteColor];
textLabel1.backgroundColor = [UIColor blackColor];
textLabel1.numberOfLines = 1;
textLabel1.adjustsFontSizeToFitWidth = NO;
[textLabel1 setFont:[UIFont boldSystemFontOfSize:19]];
[cell.contentView addSubview:textLabel1];
[textLabel1 release];
} else {
textLabel1 = (UILabel *)[cell.contentView viewWithTag:1];
}
NSDictionary *tmpDict = [listOfInfo objectForKey:[NSString stringWithFormat:@"%@",indexPath.row]];
textLabel1.text = [tmpDict objectForKey:@"name"];
return cell;
}
-(void) readDatabase {
NSArray *documentPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);
NSString *documentsDir = [documentPaths objectAtIndex:0];
databasePath = [documentsDir stringByAppendingPathComponent:[NSString stringWithFormat:@"%@",myDB]];
sqlite3 *database;
if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) {
const char sqlStatement = [[NSString stringWithFormat:@"select id,name from %@ order by orderid",myTable] UTF8String];
sqlite3_stmt *compiledStatement;
if(sqlite3_prepare_v2(database, sqlStatement, -1, &compiledStatement, NULL) == SQLITE_OK) {
while(sqlite3_step(compiledStatement) == SQLITE_ROW) {
NSString *tmpid = [NSString stringWithUTF8String:(char *)sqlite3_column_text(compiledStatement, 0)];
NSString *tmpname = [NSString stringWithCString:(const char *)sqlite3_column_text(compiledStatement, 1) encoding:NSUTF8StringEncoding];
[listOfInfo setObject:[[NSMutableDictionary alloc] init] forKey:tmpid];
[[listOfInfo objectForKey:tmpid] setObject:[NSString stringWithFormat:@"%@", tmpname] forKey:@"name"];
}
}
sqlite3_finalize(compiledStatement);
debugNSLog(@"sqlite closing");
}
sqlite3_close(database);
}
when i change the line
NSString *tmpname = [NSString stringWithCString:(const char *)sqlite3_column_text(compiledStatement, 1) encoding:NSUTF8StringEncoding];
to
NSString *tmpname = [NSString stringWithCString:(const char *)sqlite3_column_text(compiledStatement, 1) encoding:NSASCIIStringEncoding];
the memory leak is gone
i tried NSString stringWithUTF8String and it still leak.
i've also tried:
NSData *dtmpname = [NSData dataWithBytes:sqlite3_column_blob(compiledStatement, 1) length:sqlite3_column_bytes(compiledStatement, 1)];
NSString *tmpname = [[[NSString alloc] initWithData:dtmpname encoding:NSUTF8StringEncoding] autorelease];
and the problem remains, the leak occur when u start scrolling the tableview.
i've actually tried other encoding and it seems that only NSASCIIStringEncoding works(no memory leak)
any idea how to get rid of this problem?