Symptom
- Column is defined as a real, float, or double precision datatype
- Select on column shows
c1
--------
0.000100
0.000010
0.000010
- Ouput from BCP using the -c option shows in exponential format
cat BCP.out
.0001
1.0000000000000001e-05
1.0000000000000001e-05
Read more...
Environment
- BCP all Versions
Product
SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5
Keywords
BCP, float, exponential, scientific notation, e-notation, real, double, precision, floating , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.