2 files changed, 50 insertions, 4 deletions

diff --git a/README.md b/README.md
index 658498e..7937862 100644
--- a/README.md
+++ b/README.md
@@ -119,4 +119,12 @@ Since sqlite doesn't have many [types](https://www.sqlite.org/datatype3.html) on
 Here are the rules for bind parameters:
 * any Zig `Int` or `ComptimeInt` is tread as a `INTEGER`.
 * any Zig `Float` or `ComptimeFloat` is treated as a `REAL`.
-* `[]const u8`, `[]u8` or any array of `u8` is treated as a `TEXT` or `BLOB`.
+* `[]const u8`, `[]u8` or any array of `u8` is treated as a `TEXT`.
+* The custom `sqlite.Bytes` type is treated as a `TEXT` or `BLOB`.
+
+Here are the resules for resultset rows:
+* `INTEGER` can be read into any Zig `Int` provided the data fits.
+* `REAL` can be read into any Zig `Float` provided the data fits.
+* `TEXT` can be read into a `[]const u8` or `[]u8`.
+* `TEXT` can be read into any array of `u8` provided the data fits.
+* `BLOB` follows the same rules as `TEXT`.
diff --git a/sqlite.zig b/sqlite.zig
index 46f2e7e..116807a 100644
--- a/sqlite.zig
+++ b/sqlite.zig
@@ -117,6 +117,17 @@ pub const Db = struct {
     }
 };
 
+/// Bytes is used to represent a byte slice with its SQLite datatype.
+///
+/// Since Zig doesn't have strings we can't tell if a []u8 must be stored as a SQLite TEXT or BLOB,
+/// this type can be used to communicate this when executing a statement.
+///
+/// If a []u8 or []const u8 is passed as bind parameter it will be treated as TEXT.
+pub const Bytes = union(enum) {
+    Blob: []const u8,
+    Text: []const u8,
+};
+
 /// Statement is a wrapper around a SQLite statement, providing high-level functions to execute
 /// a statement and retrieve rows for SELECT queries.
 ///
@@ -153,11 +164,17 @@ pub const Statement = struct {
 
     stmt: *c.sqlite3_stmt,
 
+    const BytesType = enum {
+        Text,
+        Blob,
+    };
+
     fn prepare(db: *Db, flags: c_uint, comptime query: []const u8, values: anytype) !Self {
-        const StructType = @typeInfo(@TypeOf(values)).Struct;
+        const StructType = @TypeOf(values);
+        const StructTypeInfo = @typeInfo(StructType).Struct;
         comptime {
             const bind_parameter_count = std.mem.count(u8, query, "?");
-            if (bind_parameter_count != StructType.fields.len) {
+            if (bind_parameter_count != StructTypeInfo.fields.len) {
                 @compileError("bind parameter count != number of fields in tuple/struct");
             }
         }
@@ -183,7 +200,7 @@ pub const Statement = struct {
 
         // Bind
 
-        inline for (StructType.fields) |struct_field, _i| {
+        inline for (StructTypeInfo.fields) |struct_field, _i| {
             const i = @as(usize, _i);
             const field_type_info = @typeInfo(struct_field.field_type);
             const field_value = @field(values, struct_field.name);
@@ -193,6 +210,10 @@ pub const Statement = struct {
                 []const u8, []u8 => {
                     _ = c.sqlite3_bind_text(stmt, column, field_value.ptr, @intCast(c_int, field_value.len), null);
                 },
+                Bytes => switch (field_value) {
+                    .Text => |v| _ = c.sqlite3_bind_text(stmt, column, v.ptr, @intCast(c_int, v.len), null),
+                    .Blob => |v| _ = c.sqlite3_bind_blob(stmt, column, v.ptr, @intCast(c_int, v.len), null),
+                },
                 else => switch (field_type_info) {
                     .Int, .ComptimeInt => _ = c.sqlite3_bind_int64(stmt, column, @intCast(c_longlong, field_value)),
                     .Float, .ComptimeFloat => _ = c.sqlite3_bind_double(stmt, column, field_value),
@@ -512,6 +533,23 @@ test "sqlite: statement exec" {
 
         testing.expectEqual(@as(usize, 33), age.?);
     }
+
+    // Test with a Bytes struct
+
+    {
+        // NOTE(vincent): can't yet pass an anonymous struct, the compiler crashes.
+        const Params = struct {
+            id: usize,
+            name: Bytes,
+            age: usize,
+        };
+
+        try db.exec("INSERT INTO user(id, name, age) VALUES(?, ?, ?)", Params{
+            .id = 200,
+            .name = .{ .Text = "hello" },
+            .age = 20,
+        });
+    }
 }
 
 fn dbMode() Db.Mode {