Re: Issue with legacy informix driver

mbristol@my-dejanews.com offerred: +This behavior only shows up when crossing a platform boundary into or out of +DEC4.0 land, i.e. a driver built on DEC 4.0d accessing a database on Solaris +2.6, SunOS 4.14 or HP-UX 10.20 sees the sqltype as SQLDECIMAL, while the same +code running against a native 4.0d database works fine (i.e flag it as +SQLSMALLFLT). Conversely, going from a non-Dec into Dec shows the problem +(same code), but avoiding Dec all together doesn't. So I'm figuring there is +obviously a platform dependancy issue here or else some XX-bit thing I'm +ignorant of. The versions running on either side are one of 7.23 or 7.24, +but the DEC one has a .F?? version tacked on the end, while the other have +.U?? ... Oh sure, NOW you tell me this, after I've embarassed myself by giving a wrong answer ;-) It was important info. Since float and double types are repesented differently on different platforms (significant word order and such), Informix also does a conversion to decimal when sending results out over the network to ensure the data received is appropriate to the remote system. A decimal is a decimal on any platform, so it becomes the "universal" type in this case. If I recall correctly, the U is for generic Unix; F is for OSF, Dec's interpretation of Unix ;-). Dave ** Dave Kosenk <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training