views:

525

answers:

2

hi all, I use this code to read data from sqlite database:

keyFromSql = [NSString stringWithCString:(char *)sqlite3_column_text(preparedStatement, 1)];

but the compiler give me the warning wrote in the title... so, what is the right and not deprecated method to retrieve a value from sqlite?

thanks!

+2  A: 

Since SQLite always return UTF-8* encoded strings, you could just use +stringWithUTF8String:.

const char* res = (const char*)sqlite3_column_text(preparedStatement, 1);
keyFromSql = [NSString stringWithUTF8String:res];

(* or UTF-16, if you use sqlite3_column_text16)

KennyTM
+2  A: 
+(id)stringWithCString:(const char *)cString encoding:(NSStringEncoding)enc

I think you'll typically use NSUTF8StringEncoding, so your code would look like

keyFromSq1 = [NSString stringWithCString:(char *)sqlite3_column_text(preparedStatement, 1) encoding:NSUTF8StringEncoding];

Alternatively you can use

keyFromSq1 = [NSString stringWithUTF8String:(char *)sqlite3_column_text(preparedStatement, 1)];
Austen Green