Skip to content

Instantly share code, notes, and snippets.

View SakiTakamachi's full-sized avatar

Saki Takamachi SakiTakamachi

149 followers · 1 following
View GitHub Profile
@SakiTakamachi
SakiTakamachi / sqlite_blob.c
Created April 15, 2024 15:37
#include <stdio.h>
#include <string.h>
#include <sqlite3.h>
void select(sqlite3 *db) {
const char *tail;
sqlite3_stmt *stmt;
char *query = "SELECT x'666f6f00626172';";
sqlite3_prepare_v2(db, query, strlen(query)-1, &stmt, &tail);
@SakiTakamachi
SakiTakamachi / sqlite.c
Created April 15, 2024 13:50
SQLite: Results of queries containing null bytes may be incorrect
#include <stdio.h>
#include <string.h>
#include <sqlite3.h>
void select(sqlite3 *db) {
const char *tail;
sqlite3_stmt *stmt;
char *query = "SELECT 'foo'||x'00'||'bar';";
sqlite3_prepare_v2(db, query, strlen(query)-1, &stmt, &tail);