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".

As an additional question - how many drivers actually impelement
column_info() ?

(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).

Michael
-- 
Michael Peppler / [EMAIL PROTECTED] / http://www.mbay.net/~mpeppler
[EMAIL PROTECTED] / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to