FreeTDS Development Group

["Eric Deutsch" <edeutsch AT systemsbiology.org>]

Hi Freddy, that fixed it, many thanks!

Eric


> -----Original Message-----
> From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
> Sent: Tuesday, September 03, 2002 11:28 PM
> To: TDS Development Group
> Subject: [freetds] Re: Nonfunctional datatype: UNIQUEIDENTIFIER
> 
> Il mar, 2002-09-03 alle 22:00, Eric Deutsch ha scritto:
> >
> > Hi, I inherited a table from someone else that has the datatype
> UNIQUEIDENTIFIER, which is supported by MSSQL 2000 at least.  This is a
> GUID type thingy.  It is a 16-byte value typically displayed in 32 hex
> digits like:
> >
> > 9E79F6C1-8327-11D0-A9CE-02608C8F74F1
> >
> > When I do a query against such a column (using DBD::Sybase), I get:
> >
> 
> Well, problem is not FreeTDS but DBD::Sybase. Simply it do not expect
> this type...
> 
> Uncompress source, edit C file replacing
> 
>       case CS_NUMERIC_TYPE:
>       case CS_DECIMAL_TYPE:
>         len = (CS_MAX_PREC + 2);
>         break;
> 
>       default:
>         len = column->maxlength;
>         break;
> 
> with
> 
>       case CS_NUMERIC_TYPE:
>       case CS_DECIMAL_TYPE:
>         len = (CS_MAX_PREC + 2);
>         break;
> 
> #ifdef CS_UNIQUE_TYPE
>       case CS_UNIQUE_TYPE:
>               len = 40;
>               break;
> #endif
> 
>       default:
>         len = column->maxlength;
>         break;
> 
> Should work...
> 
> > [QUERY]: SELECT TOP 5 ConditionsID,s_GUID FROM accesstemp.dbo.[Human PCR
> Conditions]
> > error_handler: Data-conversion resulted in overflow.
> > =-2104898907|šÂ@=
> > error_handler: Data-conversion resulted in overflow.
> > =-2102394566|šÂ@=
> > error_handler: Data-conversion resulted in overflow.
> > =-2098241821|šÂ@=
> > error_handler: Data-conversion resulted in overflow.
> > =-2097918306|šÂ@=
> > error_handler: Data-conversion resulted in overflow.
> > =-2094131412|šÂ@=
> >
> > The first column is correct, but the second appears to be garbled junk.
> In one test, I got the program to dump a 1 GB core, but that doesn't
> always happen.
> >
> > Any ideas on how to fix this?
> >
> > Thanks,
> > Eric
> >
> freddy77
> 
> 
> 
> ---
> You are currently subscribed to freetds as:
> [edeutsch AT exchange.systemsbiology.org]
> To unsubscribe, forward this message to leave-freetds-
> 149102K AT franklin.oit.unc.edu