SAP Knowledge Base Article - Preview

3283018 - Numbers in e-notation become incorrect when inserted into FLOAT datatypes - SAP ASE

Symptom

  • Numbers in e-notation are corrupted when converted to floating point datatypes
  • Only the digit before the decimal point is stored
  • For example "2.5e15" becomes 2.0


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Configuration "enable pci" is set on
  • Microsoft Windows
    • Region configuration set to "German (Germany)"  [possibly others] 
    • "Decimal Symbol"configuration set to comma (',')

Product

SAP Adaptive Server Enterprise 16.0

Keywords

float, floating, real, double, atof, wrong, value, corrupt, result, e-notation, e notation, scientific notation, number, numeric, region, decimal, truncate, Sybase, ASEServer, SAPASE, dataserver, CR646295, CR#646295, 646295 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

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

Search for additional results

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