SourceForge has been redesigned. Learn more.

Output Window is rounding floats to integers

Shann Can
  • Shann Can

    Shann Can - 2008-11-20


    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.

    Any ideas?


    • Shann Can

      Shann Can - 2008-11-21

      Anyone getting this issue?

      If it helps - I am using the Sybase Adaptive Server Anywhere driver - jconn3.jar.

    • Heiko Hilbert

      Heiko Hilbert - 2008-11-21

      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.

  • riaan

    riaan - 2009-10-09

    Tested using the script given above, output was 1. This was with MSSQL 2005 and MS sqljdbc driver.

  • Heiko Hilbert

    Heiko Hilbert - 2009-10-18

    should be fixed with 3.5.1


Log in to post a comment.