In SQL, implicit conversion from TEXT to BLOB doesn’t work in the way you're thinking. You need to provide binary data for the BLOB column explicitly.

INSERT INTO "non_strict_table" ("name", "data") VALUES ('name_01', CAST('blob_data' AS BLOB));

This converts the string 'blob_data' to a BLOB and stores it.