SAP Knowledge Base Article - Preview

2892512 - ADO.NET : Trailing zeros are trimmed from a decimal number - SDK for SAP ASE

Symptom

  • For example, you are retrieving rows from a table with a decimal(16,8) column.
  • isql shows as below.
1> select * from decimaltest
2> go
 col1
 -------------------
          1.00000000
         12.78900000
        156.89017000
       3001.00000000
       5670.60000000
(5 rows affected)
1>
  • On the other hand, using ADO.NET Data Provider, decimal numbers are displayed without trailing zeros.
1
12.789
156.89017
3001
5670.6


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • Adaptive Server Enterprise ADO.NET Data Provider
  • Microsoft Windows

Product

SAP Adaptive Server Enterprise SDK 16.0 ; Sybase Software Developer Kit 15.7

Keywords

ADO.NET, ToString, CR#759103, 759103, #759103 , KBA , BC-SYB-SDK , SDK , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.