Re: Informix/ODBC/Text datatypes

The behaviour is in both cases correct (or maybe not). ODBC does not know any serials so the datatype is converted to a number. ODBC 2.5 does not know any exact numbers (decimal,numeric) so again a standard conversion is used to represent the number without rounding. Of course the apllication could then interpret this string again.. BTW upcomming ODBC 3.0 knows decimals (they are represented by a C struct) . "Reiner Kunz" <Reiner.Kunz@pr-kunz2.M.eunet.de> wrote: >> Some ODBC drivers handle it more gracefully than others. Either=20 >> Visigenics or Intersolv (apologies, I don't remember which) lets you = >do a=20 >> simple "select txt from xxx where ..." > >Hi William, > >and what about other informix data types. I'm trying to access Informix = >Online 7.12 with Access97 via Informix-CLI 2.5 (this driver seems to = >come from Intersolv). So, DECIMAL/MONEY converts to a text string. And a = >SERIAL becomes a number. Any ideas why this happens? And is it an Access = >problem or just an ODBC problem? Many thanks for your help! > > >--=20 >cu Reiner (munich, germany)