On Wed, 24 Sep 2014 09:49:36 -0400
Richard Hipp <d...@sqlite.org> 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to