1

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?

Jasper_07
  • 2,453
  • 2
  • 18
  • 23

1 Answers1

5

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.

hoffman
  • 420
  • 5
  • 9
  • thanks - I get that the SQL Types are predefined, in ABAP and other techniques you can change the default Edm mappings via config, thought there may have been something similar, would be handy – Jasper_07 Jun 28 '14 at 10:06
  • I had the same thought about using 0/1, then i remembered in js x = 0; (x) === true, I know (!!x) === false but want something that works out of the box – Jasper_07 Jun 28 '14 at 10:10
  • @Jasper_07 so in the end - did it solve your problem? In case yes, would be happy if you mark it as answered :) Thanks! – hoffman May 20 '16 at 12:54