Has anyone come across this?
Everytime I run a sql query against a table with float data types in it - the columns are rounded to integers.
This is while running against a Sybase db.
I haven't been able to test against other db servers.
It is pretty annoying and I've gone through , what I think is, every option in the menus and don't see any reference to floats/decimals being rounded to integers.
Anyone getting this issue?
If it helps - I am using the Sybase Adaptive Server Anywhere driver - jconn3.jar.
I checked this with Adaptive Server 12.5 and jconn3.jar:
create table t1(x float);
insert into t1 values(1.345);
select * from t1;
drop table t1;
Th output was:
Can you run this script against your db.
I currently have no ASA installed.
Tested using the script given above, output was 1. This was with MSSQL 2005 and MS sqljdbc driver.
should be fixed with 3.5.1