PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: CTlib - problems with ct_col_types
Date: Sep 30 1997 2:13PM

Interesting problem. I will look into it too.

Michael

Heinz Ringlhofer wrote:
> 
> After digging deeper into this problem, this seems to be also a deficiency
> on the client (server - whatever):
> 
>  - We are using (unfortunately - historical reasons) tiny integers
>    with the NULL option. This maps to type = 38 and usertype = 5 in
>    systypes. The name of type 38 (in systypes) is intn. A small int
>    with the NULL option maps to type = 38 and usertype = 6, an int
>    (with NULL) maps to type = 56, usertype = 7. So we would really
>    need to get both usertype and type from ct_col_types back...
> 
> On Sep 29,  9:01am, Michael Peppler wrote:
> > Subject: Re: CTlib - problems with ct_col_types
> > Heinz Ringlhofer wrote:
> > >
> > > I try to use ct_col_types to find out what data types my columns are.
> > > In particular, i would like to get onto tiny integers.
> > > However the call returns 8 (CS_INT_TYPE) for both tiny, small and normal
> > > integers.
> > >
> > > Do you have any clues ??
> >
> > Yes.
> >
> > That's a bug :-)
> >
> > I'll fix it for next release.
> >
> > Michael
> > --
> > Michael Peppler       -||-  Data Migrations Inc.
> > mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler
> >-- End of excerpt from Michael Peppler
> 
> --
>  +---------------------------------------------------------------------------+
>  |     Heinz Ringlhofer                        Central Institute for         |
>  |     Heinz.Ringlhofer@zamg.ac.at             Meteorology and Geodynamics   |
>  |     +43 (1) 36026-2608                      Hohe Warte 38, A-1191 Vienna  |
>  +---------------------------------------------------------------------------+

-- 
Michael Peppler       -||-  Data Migrations Inc.
mpeppler@datamig.com  -||-  http://www.mbay.net/~mpeppler