Handle bool values with "BOOLEAN" columns.

1 files changed, 5 insertions, 2 deletions

diff --git a/sqlite3.go b/sqlite3.go
index bff9aec..161da5e 100644
--- a/sqlite3.go
+++ b/sqlite3.go
@@ -284,9 +284,12 @@ func (rc *SQLiteRows) Next(dest []driver.Value) error {
 		switch C.sqlite3_column_type(rc.s.s, C.int(i)) {
 		case C.SQLITE_INTEGER:
 			val := int64(C.sqlite3_column_int64(rc.s.s, C.int(i)))
-			if rc.decltype[i] == "timestamp" {
+			switch rc.decltype[i]{
+			case "timestamp":
 				dest[i] = time.Unix(val, 0)
-			} else {
+			case "boolean":
+				dest[i] = val>0
+			default:
 				dest[i] = val
 			}
 		case C.SQLITE_FLOAT: