Quoth Tito Ciuro <tci...@mac.com>, on 2010-11-06 20:35:10 -0300:
> "None: A column with a none affinity has no preference over storage
> class. Each value is stored as the type provided, with no attempt to
> convert anything."

Note that type affinities are not usually specified as column types
directly.  Instead, an SQL column type is used.  In fact, the column
type "NONE" will be detected as NUMERIC affinity, per the rules in the
documentation.  I would use a blank type to declare a column of
varying type; that would give the NONE affinity you desire.

   ---> Drake Wilson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to