Server (on Gentoo linux): postgresql-7.4.7
Windows client: psqlodbc-07.03.0200
I get perfect results when I use pgAdmin or directly on the console, but
when I use Excel or Access through ODBC, I get corrupted numbers (using
the same SQL command). The data corruption is consistent (same wrong
number every time). The data type for all fields is float4. I've tried
newer snapshot versions of psqlodbc and different clients, no luck.
This also occurred with postgresql 7.3 on our old RH box...
Correct:
2.5246,2.1749,229.04,30.148,0.92686,41.7
Excel/Access results:
2.5246,2.1749001,229.03999,30.148001,0.92685997,41.700001
Any suggestions?