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 >