[libdbi-users] sqlite and sqlite3 drivers CHAR as TEXT or INTEGER

2008-10-23 Thread João Henrique Freitas
Hello, I need a simple clarification: drivers/sqlite/dbd_sqlite.c 837 else if (strstr(curr_type, "CHAR") /* this is a 1-byte value */ 838 || strstr(curr_type, "TINYINT") 839 || strstr(curr_type, "INT1")) { 840 type = FIELD_TYPE_TINY; 841 } drivers/sqlite3/dbd_sqlite3

Re: [libdbi-users] sqlite and sqlite3 drivers CHAR as TEXT or INTEGER

2008-10-23 Thread Claudiu CISMARU
> But http://sqlite.org/datatypes.html and > http://sqlite.org/datatype3.html says: > > "The search for these strings in the type declaration is case > insensitive, of course. If any of the above strings occur anywhere in > the type declaration, then the datatype of the column is text. Notice >