Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Avis, Ed" <avised at kbcfp dot com>
Subject: Meaning of TYPE_NAME in type_info() output
Date: May 6 2005 4:37PM

If I make a user-defined type synonym, should the name of this synonym
appear as TYPE_NAME in the type_info() output or should TYPE_NAME give
the original SQL type the synonym is defined as?

Currently if I make a user-defined type on Sybase and use it for some
column C of a table T, then for 'SELECT C FROM T' DBD::Sybase gives me
the name of the user type.  I think I would prefer it to give the
original SQL like 'varchar(10)' in the TYPE_NAME field, but I don't know
what other DBDs do.

What is the intended behaviour of TYPE_NAME in this case?  I'm sure
other RDBMSes allow user-defined type synonyms.

I think it would be best to resolve the synonym down to plain SQL type
name if possible - but if that isn't possible (eg it really is a user-
defined type, not just a synonym) then leave the name.

Ed Avis