freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [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.

From: Jean Uwacu <jean.uwacu AT freemindconsulting.com>
To: freetds AT lists.ibiblio.org
Subject: Re: [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.
Date: Fri, 22 Jul 2005 13:44:24 +0200

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

[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, 07/20/2005
- Re: [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., James K. Lowden, 07/21/2005
- Re: [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, 07/22/2005