Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

INFO: Last Trailing Zero in Numeric Field Truncated with Sybase Database

View products that this article applies to.

This article was previously published under Q222120

↑ Back to the top


While using ADO to access a Sybase database table using an ADO server-side cursor (adUseServer), the last trailing zero in a numeric field is truncated. This happens while accessing the Sybase database through the Microsoft OLE DB provider for ODBC using the Intersolv 3.11 32-bit Sybase ODBC driver (

↑ Back to the top

More information

To avoid the truncation, use ADO's client-side cursor (adUseClient).

↑ Back to the top

Keywords: KB222120, kbinfo, kbdatabase, kb3rdparty

↑ Back to the top

Article Info
Article ID : 222120
Revision : 3
Created on : 5/10/2003
Published on : 5/10/2003
Exists online : False
Views : 423