[freetds] solaris 5.7, perl v5.8.5, freetds 0.62.4, DBD::Sybase-1.05_02 doesn't recognize the column type of a table database.
Jean Uwacu
jean.uwacu at freemindconsulting.com
Fri Jul 22 07:44:24 EDT 2005
In fact i get integer but those are not displayed nor processed as integers.
Here is the results of a basic select request with DBI and DBD::Sybase:
'select Node, Serial, Sever from alerts.status where Class = 101;'
The results received are:
for the failing script on
olivier 3å Ether
olivier 3ä Ether:1
and the same request would have done:
olivier 8664037 Ether 3
olivier 8664036 Ether:1 5
The surprising thing is that for this request tsql give me each time the right results.
Thanks.
P.S.: Here is another table matching received numbers to the expected:
F
Fç
F¸
Fé
¾Æ]
¿{X
¿´
f:
ÁLÏ
3ä
Àºª
ÁL£
Àÿª
}CX
Àÿ©
3õ
¿1
|ë]
¿5
®¡
®³
$
®Ò
®Û
®×
Ø
Á 6
À
¿{d
¿{a
ý
ç
×Ì
8668845
8668903
8668856
8668905
62834269
62880600
62895131
8807994
62999759
8664036
62962346
62999715
62980010
8209240
62980009
8664053
62883121
8186717
62862593
8760993
8761011
8856599
8761042
8761051
8761047
8656088
62988342
62922779
62880612
62880609
8720381
8710061
8771532
More information about the FreeTDS
mailing list