It is possible to have DBI return information on the types that it knows about. Look at type_info_all and type_info.

my $type_info = $dbh->type_info($data_type);
print "Name: ", $type_info->{TYPE_NAME};
print "Type: ", $type_info->{DATA_TYPE};
[download]