DBD::mysql::AutoTypes -- automatically assign parameters' sql type to support old DBD::mysql functionality
use DBI; use DBD::mysql::AutoTypes; my $dbh = DBI->connect('DBI:mysql:...', '...', '...') and mysql_auto_types();
Since version 2.9002 DBD::mysql requires explicit sql type for query parameters. You should change the tonnes of $dbh->selectall_arrayref() to the ugly "prepare - bind - execute - fetch" pipeline.
This module is provided to solve the problem.
You have to change only two lines of code (use the module, and apply fixup after accuring database connection).
DBI
DBD::mysql
Regexp::Common
May be...
DBI -- Perl DataBase Interface (http://search.cpan.org/~timb/DBI/)
DBD::mysql -- MySQL (http://www.mysql.com) driver (http://search.cpan.org/~rudy/DBD-mysql/) and DBD::mysql ChangeLog -- look for the version 2.9002 changes (http://search.cpan.org/src/RUDY/DBD-mysql-2.9002/ChangeLog), that break old behaviour
Regexp::Common -- determine is data number or string
Greg "Grishace" Belenky <greg@webzavod.ru>
Copyright (C) 2004 Greg "Grishace" Belenky Portions of code cut'n'pasted from the DBI module
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
To install DBD::mysql::AutoTypes, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBD::mysql::AutoTypes
CPAN shell
perl -MCPAN -e shell install DBD::mysql::AutoTypes
For more information on module installation, please visit the detailed CPAN module installation guide.