Skip to Content.
Sympa Menu

freetds - Re: [freetds] sqsh + FreeTDS + binary datatype = huh?!?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Wood, David" <David.Wood AT deshaw.com>
  • To: <jklowden AT freetds.org>
  • Cc: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] sqsh + FreeTDS + binary datatype = huh?!?
  • Date: Thu, 19 Apr 2007 04:16:28 -0400

> Great! I'm ready to sit back, put up my feet and rest on my laurels
-- we
> keep laurels around just for that reason, you know, just in case --
and
> you go and find a bug. Thanks a bunch!

:-D

> I made some guesses about your datatype. Can you tell me how that
> asset_id column is defined?

Sure! I created a really small test case:

1> create table asset (asset_id binary(8), cusip char(9) null, isin_nm
varchar(20) null)
2> go
1> insert into asset values (0x00038602ab1a93a5, 'US68572YAA82',
'68572YAA8')
2> go
1> select asset_id, isin_nm, cusip from asset where
asset_id=0x00038602ab1a93a5
2> go
1> select asset_id from asset where asset_id=0x00038602ab1a93a5
2> go

David




Archive powered by MHonArc 2.6.24.

Top of Page