On 26 Jan 2012, at 12:15pm, darkelf wrote: > rez = sqlite3_exec(ss_pdb, "CREATE TABLE T(str STRING, val INTEGER);", NULL, > NULL, NULL);
Datatypes in SQLite are as follows: http://www.sqlite.org/datatype3.html Your word 'STRING' is being interpreted as a numeric affinity. And as the value you provide can be understood as a number, SQLite is storing the number. It would be more appropriate to define the 'str' column as 'TEXT'. Hope this helps. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
