I need a list of values for the DBI statement handle attribute TYPE

rinceWind has asked for the wisdom of the Perl Monks concerning the following question:

I am trying to use a script I have already published to Perlmonks here. The script was designed to be database generic, and in principle it is. I have just successfully hacked the first few lines to allow my current database to be analysed.

Considering the original post was written with an Oracle database in mind, and I am now using it for Sybase, I am pleased that my original script works. However, I have an issue with the decoding of data types as the DBD layer is returning different values for $sth->{TYPE}. I am getting different 'magic' numbers, but I do not have the complete infomation to decode them. I would like a comprehensive list for the standard values that will occur.

The two references I have seen quoted for this information in the documentation both don't work:

Can anyone please post the current list of values as a reply, or a url which works (preferrably http rather than ftp).

Thanks in anticipation.

rinceWind

--
I'm Not Just Another Perl Hacker

Comment on I need a list of values for the DBI statement handle attribute TYPE

Replies are listed 'Best First'.

Re: I need a list of values for the DBI statement handle attribute TYPE
by pfaut (Priest) on Feb 25, 2004 at 02:07 UTC

Are you looking for this little tidbit buried in the DBI POD?

       Constants representing the values of the SQL standard types can
+ be
       imported individually by name, or all together by importing the
+ special
       ":sql_types" tag.

       The names and values of all the defined SQL standard types can 
+be pro-
       duced like this:

         foreach (@{ $DBI::EXPORT_TAGS{sql_types} }) {
           printf "%s=%d\n", $_, &{"DBI::$_"};
         }
[download]

90% of every Perl application is already written. ⇒

dragonchild

[reply]
[d/l]

Re^2: I need a list of values for the DBI statement handle attribute TYPE

by Anonymous Monk on Apr 01, 2007 at 17:34 UTC

> foreach (@{ $DBI::EXPORT_TAGS{sql_types} }) { > printf "%s=%d\n", $_, &{"DBI::$_"}; > } It fails with "use strict", and I can't see how to define that variable.

[reply]

Re: I need a list of values for the DBI statement handle attribute TYPE
by iburrell (Chaplain) on Feb 25, 2004 at 20:23 UTC

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

[reply]
[d/l]


P is for Practical
	PerlMonks