On Wed, 24 Sep 2014 09:49:36 -0400
Richard Hipp <[email protected]> wrote:
> > * SQL injection attacks;
> >
>
> You are doing CREATE TABLE statements based on text from an untrusted
> user? Really?
My reaction exactly.
> > * floating point value rounding in conversion to/from text;
If the default cannot be represented exactly, its rounding will be the
least of the difficulties.
> > * how else can I set a default value for a binary blob column?
http://www.sqlite.org/lang_expr.html
"BLOB literals are string literals containing hexadecimal data
and preceded by a single "x" or "X" character. Example: X'53514C697465'"
HTH.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users