Basically I have a table with the column A with type int in it.
Say when I do this in SQL Query: select value1 from A, I get 21.
Here is the strange thing, I have the JSP that does the same thing, use ODBC driver to connect to the database. But instead of 21, I get 21.0.
Is there a configuration to turn this off? I know I can do Right(21.0 , 1) to get 21, but that is a hack approach.
This works fine when I use MySQL and JDBC driver, so my guess is it could be the ODBC driver.... any experts have any information about this?