Re: Problems retrieving informix value fields through ODBC

Posted in 1998

Chris Dornsife — Thu, 17 Dec 1998 11:00:57 -0800 — source: Informix-list mailing list archive (1991-1998)

>We have a software developed with Oracle Pro*C accessing data via Oracle >OCA >(Open Client Adapter) and ODBC to access Informix databases. > >All is fine except when we try to retrieve data form varchar and >smallint informix fields. In this situation we get the correct value + >garbagge (strange characters). With other >data types (i. e. char or integer) is working fine. > Try casting the columns into types that don't get mangled. select number::int from table.... select name::char(255) from table.... hope this helps