On Wed, Jul 17, 2002 at 12:14:59PM -0700, Michael Peppler wrote: > I've implemented $dbh->column_info() for DBD::Sybase, using the > sp_columns catalog stored procedure that Sybase provides. > > However - I noticed a discrepancy between the columns that the DBI > manual defines and the columns that sp_columns returns - sp_columns > returns two extra columns between REMARKS and COLUMN_DEF, called > SS_DATA_TYPE and COLID (where SS_DATA_TYPE is the internal Sybase data > type id, and COLID is really the same thing as ORDINAL_POSITION). > > I don't know which of the definitions is "wrong".
The "right" way is the ODBC way which is what the DBI spec is based on. > As an additional question - how many drivers actually impelement > column_info() ? DBD::ODBC does, I think, DBD::Oracle is about to. Others will follow. > (I just noticed that DBD::mysql doesn't, for example, and I don't know > if mysql has an easy way to get that information in a reasonable format). Tim.
