iOS:如何插入 Special like "或 ' 字符在 sqlite

问题描述

我有一个 NSString 变量，其中包含一些字符 " 和 '.那么，如何使用它作为参数插入到 Sqlite3 中的表中呢?感谢您的帮助:)

I have a NSString variable that includes some characters " and '.So, how can I use it as a parameter to insert into table in Sqlite3?Thanks for helping :)

推荐答案

为避免格式问题，请使用参数将字符串传递到 SQL 语句中:

To avoid formatting problems, use a parameter to pass the string into the SQL statement:

NSString *str = @"some characters \" and \'";
const char *sql = "INSERT INTO MyTable(Name) VALUES(?)";
sqlite3_stmt *stmt;
if (sqlite3_prepare_v2(db, sql, -1, &stmt, NULL) == SQLITE_OK) {
    sqlite3_bind_text(stmt, 1, [str UTF8String], -1, SQLITE_TRANSIENT);
    if (sqlite3_step(stmt) != SQLITE_DONE) {
        NSLog(@"SQL execution failed: %s", sqlite3_errmsg(db));
    }
} else {
    NSLog(@"SQL prepare failed: %s", sqlite3_errmsg(db));
}
sqlite3_finalize(stmt);

这篇关于iOS:如何插入 Special like "或 ' 字符在 sqlite的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！