So, I'm having some trouble with Oracle doing this strange thing with my decimal number values that I'm insertting into it. I have the oracle field value as "Number", and the number I'm insertting is a float from my C# back-end code. I've tracked the value in my program all the way until it gets insertted into the database. Say you try to insert "1.2"? The value is still 1.2 all the way to getting insertted, but once it's in the database, it turns into "1.20000004768372". All my decimal values do this, either a tiny amount over or under, and I can't find any rhyme or reason why.
Detail wise, this is done on an old Oracle 8i database, with my code being asp.net/C#. But like I said, I'm pretty sure it isn't the program doing this. Any help would be greatly appreciated!