Skip site navigation (1) Skip section navigation (2)

something is corrupting the data

From: "Elford,Andrew [Ontario]" <Andrew(dot)Elford(at)ec(dot)gc(dot)ca>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: something is corrupting the data
Date: 2005-03-15 19:57:15
Message-ID: 9B09D75DF5B3494BA06E6FE478CE9CC17B5E16@mgtserver3.ontario.int.ec.gc.ca (view raw or flat)
Thread:
Lists: pgsql-odbc
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?

Responses

pgsql-odbc by date

Next:From: Greg CampbellDate: 2005-03-15 21:29:17
Subject: Re: [Maybe Spam] something is corrupting the data
Previous:From: Ivan PetrovDate: 2005-03-15 19:50:58
Subject: Re: relation %s does not exist ??? It actually does.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group