何时使用SQLITE_TRANSIENT vs SQLITE_STATIC？

我想在sqlite3中创建/更新文本列.当我在创建/更新后检索行时,文本为"？".但是,整数值已正确保留.

我的文字陈述如下:

const char *sql = "INSERT INTO todo(title, description, priority, status, created, expires, posx, posy, updated)"
                  " VALUES('?', '?', '?', '?', '?', '?', '?', '?', '?');";
if (sqlite3_prepare_v2(database, sql, -1, &insert_statment, NULL) != SQLITE_OK)
    ...
sqlite3_bind_text(update_statment, 5, [[dt stringFromDate:self.updated] UTF8String], -1, SQLITE_TRANSIENT);