DB2 result set is adding decimals to integer and all single character fields.
Posted on 2011-10-17
We have noticed a strange problem with a new install. A little info is needed first....
We have an old application which only runs in XP and we are in the process of converting it to handle Windows 7. So we must run this app in XP Mode under Windows 7. We have installed it like this on several computers with no problems. On this last install (16 pc's) everything was fine on all except 4 of them. On these 4 PC's when we do any query, all integer fields and all single character fields get returned with an appended decimal. I logged into the db2 console and verified the decimal is not in the database. It seems to be something with db2 driver or ODBC. The app is written using Delphi 7 and we are using BDE for the Delphi to ODBC bridge. I compared a machine that it works fine on with one of the bad ones and everything in the regional settings are the same. Both machines have the same copy of the application.
Any help would be great!!