RE: T95int8 test - Perl DBD, AIX 5.3, 9.40FC3,CSDK2.90FC3
Posted in 2005
>And, I've established what the trouble is, and I've got a couple of alternative fixes for it. >The problem is actually in the code for inserting data, not the retrieval (oops - well, it had to be a problem > >coming or going; I guessed coming and it was going). The problem is that a Perl IV on a 64-bit machine has >8-.byte integers, and I was trying to stuff those 8 bytes into a 4-byte SQLINT, and it doesn't work! The fix is >to recognize when this can happen (sizeof(long) != sizeof(int4)) and the absolute value of the integer is too >big for SQLINT. The alternatives are to stuff the value into an INT8 or to format it as a string. >I'm faintly hoping to release a new version of DBD::Informix this week >- that is beginning to look somewhat optimistic. As always, Thanks for the help Jonathan. I'll keep an eye out for the new DBD::Informix. s sending to informix-list