SqlDbx Forum

Carlos Torres L.

Guest

sybase bigint round

If I assign the value 99999999999999999 to a BIGINT variable, sqldbx shows 100000000000000000.

declare @var bigint
select @var = 99999999999999999
select @var

How can I show the correct value?

sqldbxhelp

Administrator

Re: sybase bigint round

I am unable to reproduce this behavior.
What version of Sybase ASE you use and what version of Sybase Open Client.
Please note that for this to work correctly you need Sybase Open Client version 15.

Carlos Torres L.

Guest

Re: sybase bigint round

OK, thank you very much, I have sybase ASE 15.0.3 and Open Client 12.0.
I can't change this client because enterprise restrictions.

Regards, Carlos.

sqldbxhelp

Administrator

Re: sybase bigint round

That explains it.
Sybase Open Client does not supports BIGINT before version 15.
In versions before 15 BIGINT is mapped to FLOAT