reterived values are getting truncated in ODBC
we are using IDS server And I am accessing Informix database server from windows using ODBC. ODBC connection... data retreiving everything is fine... except trailing zero truncation problem in reterived data... For example. It is displaying 1, If the data returned from the server is 10 It is displaying 25, If the data returned from the server is 250 It is displaying 45, If the data returned from the server is 450000. What could be the problem... is it a problem of ODBC setup ? Please help me in this regard.
I am not a windows or ODBC person, but please clarify for the group what you mean by "it is displaying".... is this a "display" you see by looking at the ODBC layer or after the front-end application displays the data? there could be multiple layers of data change from the point the data is handed from the DB to the user. ... is ODBC changing it? is the application changing it as it formats the display?... -----Original Message----- From: torch2moon@yahoo.com [mailto:torch2moon@yahoo.com] Sent: Saturday, May 22, 2004 10:30 AM To: ids@iiug.org; forum.subscriber@iiug.org Subject: reterived values are getting truncated in ODBC [3009] we are using IDS server And I am accessing Informix database server from windows using ODBC. ODBC connection... data retreiving everything is fine... except trailing zero truncation problem in reterived data... For example. It is displaying 1, If the data returned from the server is 10 It is displaying 25, If the data returned from the server is 250 It is displaying 45, If the data returned from the server is 450000. What could be the problem... is it a problem of ODBC setup ? Please help me in this regard. ----------------------------------------- ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================