On 27/02/15 09:19, Peter Rabbitson wrote:
On 02/27/2015 10:10 AM, Martin J. Evans wrote:
When I came across this problem (not using DBIC) we started adding 0 to
every numeric column when it was fetched but that became a pain. Then,
with Tim's help I added
http://search.cpan.org/~timb/DBI-1.633/DBI.pm#sql_type_cast
http://search.cpan.org/~timb/DBI-1.633/DBI.pm#bind_col
StrictlyTyped and DiscardString
Hi Martin,
Even though I've seen them when scrolling through changelogs, I've completely
forgotten about these options, thanks for reminding me!
I'll investigate in the future if this can be better incorporated into how DBIC
does things. Thanks!
Unfortunately for you, AFAIK, only DBD::ODBC and DBD::Oracle ever added support
for them (i.e., support for attributes in bind_col and actually calling
sql_type_cast internally) - principally, because those were the only drivers I
needed it in.
http://search.cpan.org/~mjevans/DBD-ODBC-1.50/ODBC.pm#Additional_bind_col_attributes
http://search.cpan.org/~pythian/DBD-Oracle-1.74/lib/DBD/Oracle.pm#bind_col
although DBI's sql_type_cast might be useful.
Martin
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
