SAP Knowledge Base Article - Preview

1988086 - Cannot count via a select in a Bit column the number of false conversion be as it is a boolean type - SAP ASE


  • When a value which is not 0 or 1 is inserted in a bit column it is translated to 1.
  • Running a select * on that columns when a non boolean value is inserted will never return any row



SAP Adaptive Server Enterprise (ASE) all versions.


SAP Adaptive Server Enterprise all versions


bit_datatype, bit columns, data, Transact-SQL extension , 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.