FreeTDS Development Group

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

Hi Bill, thanks for looking at this.  My setup is:

Linux x86 using Perl + DBD::Sybase to MS SQL Server 2000 using TDS 7.0.
I can never remember which endian is which but it's Intel, not RISC.

The value in the database (123) IS correct (the INSERT statement is sent
plain text, anyway, so there's no opportunity for error there).  Only
the SELECT comes back bad.

Many thanks for looking into this.  I'll be happy to test anything you
have to get this resolved.  I'm also very keen to test your bcp stuff!
I haven't gotten to it yet, though.  Thanks for all that work!

Eric


> -----Original Message-----
> From: Bill Thompson [mailto:thompbil AT exchange.uk.ml.com]
> Sent: Monday, July 08, 2002 2:01 PM
> To: TDS Development Group
> Subject: [freetds] RE: pre2?
> 
> Hey Eric,
> 
> > The TEXT field fix is described above.  The NUMERIC field fix I'm
not
> > sure about.  I looked quickly at the diff between the two versions
and
> > there's lots of work on NUMERIC and nothing was immediately obvious.
> > Anyone else able to reproduce this or have ideas what could be
wrong?
> >
> Most of the Numeric messing about is down to me I'm afraid. Looks like
an
> endian/byteswapping issue. Can you tell me :
> 
> client machine (specifically is it big or little endian) ?
> target database ?
> TDSVER ?
> can you tell (independantly) if the data is corrupted IN the database
I.e
> by the insert, or is it just the select thats getting it wrong.
> 
> TIA, I'll look at it tomorrow (GMT time)
> 
> ---
> You are currently subscribed to freetds as:
[edeutsch AT systemsbiology.org]
> To unsubscribe, forward this message to leave-freetds-
> 127899P AT franklin.oit.unc.edu