On 14/07/2009 3:04 AM, Simon Slavin wrote: > On 13 Jul 2009, at 4:35pm, Wilfried Mestdagh wrote: > >> But the circumstances are not really described (possible I cannot read >> between the lines as my English is not perfect). So as far as I >> understand >> the page if I want to store / retrieve a string (which can be a >> numeric >> string) I have to create my field as "char", "text" or as "none". Is >> this >> correct?
@Wilfried: in CREATE TABLE, you should use a data type that contains "char", "clob", or "text" (uppercase or lowercase doesn't matter) -- that way the column has TEXT affinity which biases SQLite towards storing data as TEXT instead of as numbers. See example below. > > 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. """ Perhaps it's case sensitive? A weird definition of "contains"? Doesn't seem so: SQLite version 3.6.14 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table x (a text, b varchar, c char, d string); sqlite> insert into x values('1', '2', '3', '4'); sqlite> select quote(a), quote(b), quote(c), quote(d) from x; '1'|'2'|'3'|4 sqlite> select typeof(a), typeof(b), typeof(c), typeof(d) from x; text|text|text|integer sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
