Re: LibPqEasy, binary cursor, x86-64, fetch(int4) problem?

On Sat, Feb 11, 2006 at 08:28:25PM -0300, Mariano Reingart wrote:
> Hi, I recently moved a simple application from a 32bit Intel to a new AMD64 
> server (migrated from Postgres 7.2 to 8.1.2 and LibPqEasy 3.0.4), running 
> Slamd64 (Slackware port to the AMD64). Everything compiled just fine but 
> the applicattion didn't work as expected.
> When I look into the tables (with psql) I see strange values in int4 
> columns like ( 16777216, 402653184, 1124073472, ...) instead of normal ones 
> (1, 24, 67)

Convert the numbers to hex and they don't look so strange:

1  = 0x01
24 = 0x18
67 = 0x43

16777216   = 0x01000000
402653184  = 0x18000000
1124073472 = 0x43000000

That ought to hint at what's happening.

-- 
Michael Fuhr