On 14 Jul 2009, at 12:49am, John Machin wrote: > On 14/07/2009 3:04 AM, Simon Slavin wrote: >> >> The reference you were pointed to explains what happens: >> >> http://www.sqlite.org/datatype3.html#affinity >> >> So you want 'TEXT' ... 'char' doesn't mean anything to SQLite. > > @Simon: I'm not sure what you mean by that; see below: > > From the quoted URL: > """ > If the datatype of the column contains any of the strings "CHAR", > "CLOB", or "TEXT" then that column has TEXT affinity. Notice that the > type VARCHAR contains the string "CHAR" and is thus assigned TEXT > affinity. > """
Wow, I completely missed that. Sorry: you're right and I was wrong. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
