Hello, Simon. You wrote Thursday, January 26, 2012, 07:37:19:
>> 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. It helps, thank you very much. -- WBR, darkelf mailto:dark...@ukr.net _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users