FreeTDS Development Group

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

> -----Original Message-----
> From: Frediano Ziglio [mailto:freddyz77 AT tin.it]
> Sent: Wednesday, August 21, 2002 11:21 AM
> To: TDS Development Group
> Subject: [freetds] Re: Issue with IMAGE type in latest build
> 
> Il mer, 2002-08-21 alle 19:16, Eric Deutsch ha scritto:
> >
> > Hi, I just pulled down the latest from CVS and have been testing it
> > against my previous stable version.  It's looking really good!  I've
> > only come across one issue so far:
> >
> > In src/tds/convert.c:tds_convert_binary(), I see that it has been
> > totally rewritten very nicely, but it no longer prepends the '0x' to
the
> > result when converting to CHAR data.  For example, if an IMAGE field
> > contained 'A', the result used to be '0x41' but now only '41' gets
> > returned.  When doing queries in Query Analyzer, the result looks
like
> > '0x41'.  Was removing the '0x' intentional, or should it be added
back
> > in?
> >
> 
> I think removing 0x is a good think.

It does make things simpler for me so I tend to agree, but I wonder if
this change from previous behavior will upset anyone else?

> You must count that tds_convert should work for ctlib/dblib/odbc.
> query analizer use odbc and also, are you sure that 0x is not
prepended
> by query analizer.

Actually, I rather suspect that '0x' IS prepended by Query Analyzer.

> PHP for example calc len for resulting buffer with
> maxlength*2+1 (it use ctlib) meaning that it don't want 0x at all...

I'm happy to leave it out if no one else complains.

> However, good spot! I'll do a test with odbc to check this behaviour.
> 
> >
> > Thanks,
> > Eric
> >
> 
> freddy77
> 
> 
> 
> ---
> 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