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
Log in to post a comment.