Search code examples
hana-xs

SAP Hana SQL Type mapped to OData Edm.boolean


In the SAP HANA developer guide there is a list explaining SQL - EDM Type mapping

Missing is how to map from a SQL Type to Edm.Boolean, anyone know how?


Solution

  • In the SAP HANA developer guide (SPS 07) it also says that the OData implementation in SAP HANA XS supports only those SQL types listed in the mentioned list/table. Therefore Edm.Boolean is not supported.

    A workaround could be to use Edm.Byte instead of Edm.Boolean which is mapped to the TinyInt HANA SQL Type. If you only want to have a true/false or 0/1 value I think the TinyInt SQL Type is the closest you can get to a Boolean.