SqlDbx
You are not logged in.
Pages: 1
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?
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.
Offline
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.
That explains it.
Sybase Open Client does not supports BIGINT before version 15.
In versions before 15 BIGINT is mapped to FLOAT
Offline
Pages: 1