CODEWITHSUNDEEP
hana-xs
Jasper_07
Jasper_07

Reputation: 2473

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?

Upvotes: 1

Views: 1912

Answers (1)

hoffman
hoffman

Reputation: 420

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.

Upvotes: 5

Related Questions