FreeTDS Development Group

[Brian Bruns <camber AT ais.org>]

On Mon, 5 Mar 2001, Michael Peppler wrote:

>  > On Mon, 5 Mar 2001, Michael Peppler wrote:
>  > 
>  > > IMAGE are returned as binary strings if bound to an CS_IMAGE_TYPE
>  > > variable, or as a hex string if bound to a CS_TEXT_TYPE variable (in
>  > > ct_bind()).
>  > 
>  > I see.  So that API is exposing more functionality then is available in
>  > Transact-SQL, which isn't surprising.  I should have thought of that.
> 
> I didn't know about it until recently. I was assuming that doing a
> ct_bind() to CS_TEXT_TYPE or CS_IMAGE_TYPE would result in the same
> thing - and found by trial and error (though it may be documented -
> I'm not very good at reading documentation :-) that binding an IMAGE
> to CS_TEXT_TYPE has a different behaviour.
> 
> Michael
> 

Well at least that is consistant with how they treat binary and varbinary
types.  That should be easy to implement, thanks Michael.

Brian