freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] sqsh + FreeTDS + binary datatype = huh?!?
- 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
-
[freetds] sqsh + FreeTDS + binary datatype = huh?!?,
Wood, David, 04/17/2007
- Re: [freetds] sqsh + FreeTDS + binary datatype = huh?!?, James K. Lowden, 04/18/2007
- <Possible follow-up(s)>
- Re: [freetds] sqsh + FreeTDS + binary datatype = huh?!?, Wood, David, 04/19/2007
Archive powered by MHonArc 2.6.24.