FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

Jaye Mathisen writes:
 > 
 > 
 > not exactly sure what's happening.
 > 
 > float works, but a column of type money doesn't.
 > I always get 0.
 > 
 > 
 > sqsh-1.7 linked with the freeTDS libs returns the right value.
 > 
 > I did check for the "defined $_" issue from before.
 > 
 > 
 > Note that the column I'm selecting against is in a view, rather than a
 > table, but it shouldn't make any difference that I can see.
 > 
 > 
 > SQL Server 6.5 SP5A, TDS ver = 4.2
 > 
 > 
 > I haven't supped and built for a few days.
 > 
 > 
 > TIMESTAMP values don't match isql at all, and in fact, seem a little
 > clustered for valid values.
 > 
 >  timestamp: |0x00000001000ef41c|
 >  timestamp: |0x00000001000ef425|
 >  timestamp: |0x00000001000ef42f|
 > 
 > 
 > >From isql:
 > 
 >  timestamp: 0x0000000100530d0a
 >             0x000000010411f4ff
 >             0x0000000104344371
 > 
 > for the same columns.
 > 
 > sqsh matches isql as well.  So that probably means the problem is in
 > DBD::Sybase.

Weird.

DBD::Sybase doesn't do anything apart from binding the return value
(with ct_bind()) to a CS_CHAR_TYPE. I've not looked at the sqsh code,
so I don't know what Scott does that is different from my code.

Michael
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler AT peppler.org    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com