Chinese records of sqlite databse are in not accessable in iphone app

Posted by Mas on Stack Overflow See other posts from Stack Overflow or by Mas
Published on 2010-05-19T03:47:21Z Indexed on 2010/05/19 3:50 UTC
Read the original article Hit count: 262

Hi! I'm creating an iphone app. In which I'm reading data from the sqlite db and presenting it in the tableview control. Problem is that the data is in chinese language. Due to unknown reason, when I read/fetch record from the sqlite table, some records are presented and other are missed by objc. Even objc reads some columns of the missing values, But returns the nil results of the some columns. In reality these columns are not empty. I tried many solutions but didn't find any suitable. Same database is working perfectly in the android version of the app. Any one can help>

here is the code of reading the chinese records from table

Quote *q = [[Quote alloc] init];
        q.catId =   sqlite3_column_int(statement, 0);
        q.subCatId =  sqlite3_column_int(statement, 1);
        q.quote = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement, 2)]; 

and here is the some records which iphone misses ??????·??? ??????,????????! ??????,???????

Thanks

© Stack Overflow or respective owner

Related posts about objective-c

Related posts about sqlite