There is another function that you have to call to get that information.
Here is a snippet of code which does exactly that.
my @type_info = $dbh->type_info("SQL_ALL_TYPES");
foreach my $type_inf(@type_info){
my $numeric=%{$type_inf}->{DATA_TYPE};
my $typename=%{$type_inf}->{TYPE_NAME};
print "type $numeric is $typename\n";
}
And by the way, this is written in the perl documentation.
ren
----- Original Message -----
From: "Walter Joyce" <[EMAIL PROTECTED]>
To: "Michael A. Chase" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 10:18 AM
Subject: Re: DATA_TYPE
> That's where I've been looking and I haven't found it yet.
>
> - Walt
>
>
> ----- Original Message -----
> From: "Michael A. Chase" <[EMAIL PROTECTED]>
> To: "Walter Joyce" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Monday, January 29, 2001 8:34 PM
> Subject: Re: DATA_TYPE
>
>
> 'perldoc DBI'
> --
> Mac :})
> ** I may forward private database questions to the DBI mail lists.
> **
> Give a hobbit a fish and he'll eat fish for a day.
> Give a hobbit a ring and he'll eat fish for an age.
> ----- Original Message -----
> From: "Walter Joyce" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 29, 2001 4:36 PM
> Subject: DATA_TYPE
>
>
> > Where can I find information on decoding the integers returned by
> > type_info() for 'data_type', as in
> >
> > @type_info = $dbh->type_info('DATA_TYPE ');
> >
> >
> > Is there a list of standard tpyes and their numeric codes?
>
>
>
>
>
