FreeTDS Development Group

[Brian Bruns <camber AT umcc.ais.org>]

On Thu, 2 Sep 1999, Jaye Mathisen wrote:

> 
> 
> not exactly sure what's happening.
> 
> float works, but a column of type money doesn't.
> I always get 0.
>
Money currently has no conversion to float which DBD::Sybase uses.  I
believe Mark is working on this so I'll stay clear of it.
 
> 
> 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.
> 
> 
Hmm...I don't have timestamps to compare but varbinary seems to work fine:

1> use jdbc_test_bacardi
2> go
1> select * from brian
2> go
        vb                                                                    
  
------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
------------------------
        0x00000001453006ac0000000000000000                                    
  
        0x00000001457362b20000000000000000                                    
  
                                                                              
  
(2 rows affected)
1> quit
Unknown property 26
[root@amd133 sqsh-1.7.tds]# back 
[root@amd133 DBD-Sybase-0.19]# vi mytest.pl 
[root@amd133 DBD-Sybase-0.19]# perl mytest.pl 
1..12
ok 1
Switch: DBI-1.06 Switch by Tim Bunce, 1.06
Available Drivers: Sybase, ADO, ExampleP, Proxy
Unknown property 7
ok 2
ok 3
ok 4
Fields: 1
Names: vb
Null:  1
0x00000001453006ac0000000000000000
0x00000001457362b20000000000000000
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10


I'll look further, but it does seem strange that sqsh and DBD::Sybase
would return different values.

Brian