Skip to Content.
Sympa Menu

freetds - Re: Issue with IMAGE type in latest build

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Issue with IMAGE type in latest build
  • Date: 21 Aug 2002 20:21:03 +0200


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

However, good spot! I'll do a test with odbc to check this behaviour.

>
> Thanks,
> Eric
>

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page