The DBI has a (currently private) method to determine the underlying database type. It was borrowed from DBIx::AnyDBD. Take a look at _dbtype_names() in DBI.pm
I intend to extend it to use $dbh->get_info(17); (=SQL_DBMS_NAME), and give it a public api, in the medium term. I think it would be wise to keep in sync with that code, and the best way to do that would be to actually use that code, and the best way to do that would be to send me patches for any changes you may need... Tim. On Thu, Jul 17, 2003 at 01:16:00AM +0200, Claus Färber wrote: > Eugene Van Der Pijll <[EMAIL PROTECTED]> schrieb/wrote: > > Joshua Hoblitt schreef: > >> If X has identical date/time handling as Pg I'd like to see DT::F::X > >> be isa DT::F::Pg. Otherwise things might get a bit confusion for end > >> users. > > Hmmm. I count 47 different DBD modules. That means 47 DT::F modules? > > Let's see. > > The following databases will probably need full support (although some > will probably have compatible formats): > > DBD::ASAny > DBD::DB2 > DBD::Empress > DBD::Illustra > DBD::Informix > DBD::Ingres > DBD::InterBase > DBD::Oracle > DBD::Ovrimos (still listed as DBD::Altera on search.CPAN.org) > DBD::PrimeBase > DBD::QBase > DBD::RBD > DBD::Solid > DBD::Sqlflex > DBD::Sybase > DBD::Unify > DBD::mSQL > DBD::mysql > > The follwing are aliases/alternative implementations for other database > types and don't need an own implementation: > > DBD::Altera => DBD::Ovrimos > DBD::PgPP => DBD::Pg > DBD::mysqlPP => DBD::mysql > > The following databases are untyped (i.e. we need to make up a format -- > standard SQL92 -- and just use): > > DBD::CSV > DBD::RAM > DBD::Sprite > DBD::XBase > > The following are not real databases and handle SQL internally (and > hopefully use standard SQL and only standard SQL for dates): > > DBD::Excel (not implemented) > DBD::SearchServer > > The follwing drivers don't handle dates at all: > > DBD::Google > > The follwing are just connectors to other APIs or proxies: They will use > the format of the database they are actually connected to: > > DBD::ADO (?) > DBD::ODBC > DBD::Multiplex > DBD::ODBC > DBD::Recall > DBD::SQLRelay > DBD::pNET > > Modules that seem to be outdated/unmaintained anyway: > > DBD::DtfSQLmac > DBD::FreeTDS > > Claus > -- > http://www.faerber.muc.de
