On Mon, 8 Mar 2010 06:01:57 -0800 (GMT-08:00), Todd Zervas
<tazer...@earthlink.net> wrote:
> Well, yes, but only the general comment that these catalog methods ought
> to return consistent values across different types of underlaying
> databases/drivers.
>
> And, I'm looking forward to the Unify implementation and the associated
> docs as well :)
Here's where I am now:
Unify
Create as sth attributes column_info ()
uni_type/uni_type_name/length
------------------- ------------------- -------------------
--------------------------
amount FLOAT 6 FLOAT 6 -4 AMOUNT
(9, 2)
amount (5, 2) FLOAT 6 FLOAT 6 -4 AMOUNT
(5, 2)
huge amount REAL 7 REAL 7 -6 HUGE
AMOUNT (15, 2)
huge amount (5, 2) REAL 7 REAL 7 -6 HUGE
AMOUNT (5, 2)
huge amount (15, 2) REAL 7 REAL 7 -6 HUGE
AMOUNT (15, 2)
byte BINARY -2 BINARY -2 -12 BYTE (1)
byte (512) BINARY -2 BINARY -2 -12 BYTE
(512)
char CHAR 1 CHAR 1 1 CHAR (1)
char (12) CHAR 1 CHAR 1 1 CHAR (12)
currency DECIMAL 3 ? - ?
currency (9) DECIMAL 3 ? - ?
currency (7,2) DECIMAL 3 ? - ?
date DATE 9 DATE 9 -3 DATE
huge date TIMESTAMP 11 TIMESTAMP 11 -11 HUGE DATE
decimal NUMERIC 2 NUMERIC 2 2 NUMERIC
(9)
decimal (2) NUMERIC 2 SMALLINT 5 2 NUMERIC
(2)
decimal (8) NUMERIC 2 NUMERIC 2 2 NUMERIC
(8)
double precision DOUBLE PRECISION 8 DOUBLE PRECISION 8 8 DOUBLE
PRECISION (64)
float DOUBLE PRECISION 8 FLOAT 6 6 FLOAT
(64)
huge integer HUGE INTEGER -5 ? - ?
integer NUMERIC 2 NUMERIC 2 2 NUMERIC
(9)
numeric NUMERIC 2 NUMERIC 2 2 NUMERIC
(9)
numeric (2) SMALLINT 5 SMALLINT 5 2 NUMERIC
(2)
numeric (6) NUMERIC 2 NUMERIC 2 2 NUMERIC
(6)
real REAL 7 REAL 7 7 REAL (32)
smallint SMALLINT 5 SMALLINT 5 2 NUMERIC
(4)
text TEXT -1 TEXT -1 -9 TEXT
time TIME 10 TIME 10 -7 TIME
$ git clone http://repo.or.cz/r/DBD-Unify.git DBD-Unify
or get it as a tgz:
$ wget --output-document=DBD-Unify.tgz \
'http://repo.or.cz/w/DBD-Unify.git?a=snapshot;sf=tgz'
> Todd Zervas
> tazer...@earthlink.net
>
> -----Original Message-----
> >From: "H.Merijn Brand" <h.m.br...@xs4all.nl>
> >Sent: Mar 8, 2010 12:54 AM
> >To: dbi-dev@perl.org
> >Subject: Re: column_info () vs type_info ()
> >
> >On Wed, 3 Mar 2010 16:10:53 +0100, "H.Merijn Brand"
> ><h.m.br...@xs4all.nl> wrote:
> >
> >> I see a big difference in what $sth->{TYPE} returns (and the name) and
> >> what column_info () - if implemented - is returning.
> >
> >Does no-one have an opinion on this?
> >
> >I'd like to finish the Unify implementation.
> >And maybe even add some docs to DBI
--
H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/
using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00,
11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3.
http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/
http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
