Lines Matching refs:blob

25 # Tests for the CAST( AS blob), CAST( AS text) and CAST( AS numeric) built-ins
33   } blob
47     execsql {SELECT CAST(x'616263' AS blob)}
50     execsql {SELECT typeof(CAST(x'616263' AS blob))}
51   } blob
78   execsql {SELECT CAST(NULL AS blob)}
81   execsql {SELECT typeof(CAST(NULL AS blob))}
108   execsql {SELECT CAST(123 AS blob)}
111   execsql {SELECT typeof(CAST(123 AS blob))}
112 } blob
138   execsql {SELECT CAST(123.456 AS blob)}
141   execsql {SELECT typeof(CAST(123.456 AS blob))}
142 } blob
168   execsql {SELECT CAST('123abc' AS blob)}
171   execsql {SELECT typeof(CAST('123abc' AS blob))}
172 } blob
307 # the end of a blob when converting it to a number.
309   set blob "1234567890"
312   sqlite3_bind_blob -static $::STMT 1 $blob 5