freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Brian Bruns" <camber AT ais.org>
- To: freetds AT franklin.oit.unc.edu
- Subject: Re: Issue with IMAGE type in latest build
- Date: Wed, 21 Aug 2002 16:11:28 -0400
Querying sybase (all versions) with isql does have the 0x prefix, I
believe that is why it was there in the first place.
Brian
> > -----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
> >=20
> > 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?
> > >
> >=20
> > 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.
> >=20
> > >
> > > Thanks,
> > > Eric
> > >
> >=20
> > freddy77
> >=20
> >=20
> >=20
> > ---
> > 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
-
Issue with IMAGE type in latest build,
Eric Deutsch, 08/21/2002
- <Possible follow-up(s)>
- Re: Issue with IMAGE type in latest build, Frediano Ziglio, 08/21/2002
- Re: Issue with IMAGE type in latest build, Eric Deutsch, 08/21/2002
- Re: Issue with IMAGE type in latest build, Brian Bruns, 08/21/2002
- Re: Issue with IMAGE type in latest build, Frediano Ziglio, 08/21/2002
- Re: Issue with IMAGE type in latest build, Brian Bruns, 08/21/2002
- Re: Issue with IMAGE type in latest build, Lowden, James K, 08/21/2002
- Re: Issue with IMAGE type in latest build, carl dotsch, 08/21/2002
- Re: Issue with IMAGE type in latest build, carl dotsch, 08/21/2002
- Re: Issue with IMAGE type in latest build, Thompson, Bill D (London), 08/26/2002
- Re: Issue with IMAGE type in latest build, ZIGLIO Frediano, 08/26/2002
- Re: Issue with IMAGE type in latest build, Lowden, James K, 08/26/2002
- Re: Issue with IMAGE type in latest build, Varley, David(CBorn at Alcoa), 08/27/2002
- Re: Issue with IMAGE type in latest build, James K . Lowden, 08/27/2002
Archive powered by MHonArc 2.6.24.