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

2008-10-24 Thread Claudiu CISMARU
On Friday 24 October 2008 14:10:09 João Henrique Freitas wrote: > Ok > > I can't do a atoi() because is out of my control. But in change the > struct of table to include a CHAR(1) than CHAR. And I can get CHAR(1) > like string. I think you don't think this in C... -- Claudiu Nicolaie CISMARU

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

2008-10-24 Thread Markus Hoenicka
Quoting João Henrique Freitas <[EMAIL PROTECTED]>: > Ok > > I can't do a atoi() because is out of my control. But in change the > struct of table to include a CHAR(1) than CHAR. And I can get CHAR(1) > like string. > I can't claim that this was an ingenious design decision back then as it is to

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

2008-10-24 Thread João Henrique Freitas
Ok I can't do a atoi() because is out of my control. But in change the struct of table to include a CHAR(1) than CHAR. And I can get CHAR(1) like string. thanks On Thu, Oct 23, 2008 at 11:10 AM, Claudiu CISMARU <[EMAIL PROTECTED]> wrote: > >> But http://sqlite.org/datatypes.html and >> http://sq

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

2008-10-24 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 >

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 >

[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