# All SQL syntaxes that result in storing a variable-length binary.

statement ok
CREATE TABLE kanto.myschema.mytable (a BLOB);

query TT rowsort
SELECT column_name, data_type FROM myschema.information_schema.columns WHERE table_catalog='kanto' ORDER BY column_name;
----
a BinaryView

statement ok
INSERT INTO kanto.myschema.mytable VALUES (X'010203');

query ? rowsort
SELECT * FROM kanto.myschema.mytable;
----
X'010203'

# Verify that we didn't accidentally store the escaped string.
query I
SELECT length(a) FROM kanto.myschema.mytable;
----
3