Replacing double quote with single quote to store in SQLite

Question

I would like to replace all double quotes with single quotes in a string. I have tried using stringByReplacingOccurrencesOfString but it does not work. How do i make it replace all the double quotes with single quotes so that i can store it into the database?

sqlite3_stmt    *statement;

NSString *string = [NSString stringWithString:charDesc.text];
[string stringByReplacingOccurrencesOfString:@"\"" withString:@"''"];

if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK){
    NSString *insertSQL = [NSString stringWithFormat: @"UPDATE CHARACTER SET charName = \"%@\", charDescription = \"%@\" WHERE charID = %i", charName.text, charDesc.text, charID];

    const char *insert_stmt = [insertSQL UTF8String];

    sqlite3_prepare_v2(database, insert_stmt, -1, &statement, NULL);
    if (sqlite3_step(statement) == SQLITE_DONE){
        status.text = @"Succesfully Updated!";
    }else{
        status.text = @"Failed to Update!";
    }

    sqlite3_finalize(statement);
    sqlite3_close(database); 
}

You don't. You prepare the statement, bind the variables and insert the row. — trojanfoe, Sep 12 '12 at 09:12
meaning? if don't have any double quotes, i can successfully add into my database. but if i have double quotes, i won't be able to add — icee, Sep 12 '12 at 09:14
Yes you will. If you bind the variable, rather than constructing the complete statement yourself, sqlite will take care of any escaping required. — trojanfoe, Sep 12 '12 at 09:16

score 1 · Answer 1 · answered Sep 12 '12 at 09:14

1

string=[string stringByReplacingOccurrencesOfString:@"\"" withString:@"'"];

answered Sep 12 '12 at 09:14

Mil0R3

3,876
4
33
61

Replacing double quote with single quote to store in SQLite

1 Answers1