SAP Knowledge Base Article - Preview

1188394 - Retrieving 'Bit' data type from a SQL Server database via OLE DB connection


  • SQL Server DB that contains a "bit" type field.
  • This field has "true and "false" values.
  • Viewing the values of that object in a universe table using an OLEDB connection, get "0" for the value " false" and "255" for the value "true".
  • Via SQL Analyser get "1" for the value "true".



SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI


bit, Sql server, Ole DB, True, False , 1971537 , KBA , BI-BIP , Business intelligence platform , 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.