type_info_all( )

This Perl DBI function returns a reference to an array of all MySQL datatypes supported by the driver.

Syntax

$dbh->type_info_all( )

Explanation

This returns a reference to an array of all datatypes supported by the driver.

Examples

The program excerpt below shows how it may be used and will show the results of the method:

my @dbinfo = $dbh->type_info_all();
my $dbinfo_hashref = $dbinfo[0];

while( my($key,$value) = each(%$dbinfo_hashref)){
   print "$key => @$value\n"; 
}