I'm using DBIx::Class in my perl script to interact with a sqlite database.
When doing inserts/searches, what will DBIx::Class consider 'true' and 'false'?
eg:
$schema->resultset('SomeObject')->create({ some_boolean => 1, primary_key => 1 });
$schema->resultset('SomeObject')->search({ some_boolean => 'true' });
Any help or documentation is appreciated (I haven't been able to find it in the DBIx::Class docs, but maybe I'm missing something.
Thanks in advance.
http://sqlite.org/datatype3.html says that SQLite doesn't have a boolean datatype but false is stored as integer 0 and true as integer 1.