Salvatore Di Guida <diguid...@hotmail.com> wrote: > If so, why do this query return very different answers: > sqlite> select length(X'01'); > 1 > sqlite> select length(X'0'); > SQL error: unrecognized token: "X'0'" ?
X'0' is not a valid BLOB literal, so SQLite reports a syntax error. BLOB literal must consist of an even number of hexadecimal digits. >> You don't have any blobs in your table, only strings. > > How can I add a blob type in the b column? For example, by using a BLOB literal rather than a string literal in your INSERT statements. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users