Skip to Content.
Sympa Menu

freetds - [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: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] sqsh + FreeTDS + binary datatype = huh?!?
  • Date: Tue, 17 Apr 2007 23:15:19 -0400

Hello,

I have a strange problem best explained by example:

sqsh compiled against FreeTDS (broken - marked with "^^^^"):
------------------------------------------------------------
1> select asset_id, isin_nm, cusip from asset where
asset_id=0x00038602ab1a93a5
2> go
asset_id isin_nm cusip
-------------------- -------------------- ---------
0x00038602ab1a93a50800 US68572YAA82 68572YAA8
^^^^

(1 row affected)

1> select asset_id from asset where asset_id=0x00038602ab1a93a5
2> go
asset_id
--------------------
0x00038602ab1a93a5

(1 row affected)

====

tsql (no problem):
------------------
1> select asset_id, isin_nm, cusip from asset where
asset_id=0x00038602ab1a93a5
2> go
asset_id isin_nm cusip
00038602ab1a93a5 US68572YAA82 68572YAA8

1> select asset_id from asset where asset_id=0x00038602ab1a93a5
2> go
asset_id
00038602ab1a93a5
1>

====

sqsh compiled against Sybase SDK v15 (no problem):
--------------------------------------------------
1> select asset_id, isin_nm, cusip from asset where
asset_id=0x00038602ab1a93a5
2> go
asset_id isin_nm cusip
-------------------- -------------------- ---------
0x00038602ab1a93a5 US68572YAA82 68572YAA8

(1 row affected)

1> select asset_id from asset where asset_id=0x00038602ab1a93a5
2> go
asset_id
--------------------
0x00038602ab1a93a5

(1 row affected)

====

1> sp__help asset
2> go
...
Column name Type I Null Dflt Rule Table
Num
-------------------- ------------- - ---- ---- ----
-------------------- ---
asset_id binary(8 ) 0 No asset
1
...
cusip char(9 ) 0 Yes asset
35
...
isin_nm varchar(20 ) 0 Yes asset
87
...

ASE version: 12.5.2 Solaris Sparc
sqsh version: 2.1.4 (Solaris Sparc, Solaris x86, Linux all behave the
same way)
FreeTDS version: 0.64 (plus a couple of patches from the repository)

% tsql -C
Compile-time settings (established with the "configure" script):
Version: freetds v0.64
MS db-lib source compatibility: no
Sybase binary compatibility: unknown
Thread safety: yes
iconv library: yes
TDS version: 5.0
iODBC: no
unixodbc: yes

Any ideas? David




Archive powered by MHonArc 2.6.24.

Top of Page