cancel
Showing results for 
Search instead for 
Did you mean: 

Boolean Datatype HANA hdbtable

jorgehuedo
Explorer
0 Kudos

Hi,

We have defined a table with a boolean column using the create table statement, but we have the whole database definition in our project using hdbtable files.

Is there any way to define a boolean column using a hdbtable? We havent found anything in the documentation.

Thanks.

Jorge

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

I assume you mean the old repository hdbtable. If so it is not supported and I would highly doubt it would ever be added. The repository is deprecated and its development artifacts receive no further enhancements. However this data type is supported in HDI. It works in both the new DDL syntax based hdbtable and it works in hdbcds.

Answers (1)

Answers (1)

KonradZaleski
Active Contributor
0 Kudos

It seems that BOOLEAN data type is not supported in hdbtable. Here is the list of data types supported by hdb tables:

The following configuration schema illustrates the data types you can specify with the sqlType keyword:

enum SqlDataType 
{
 DATE; TIME; TIMESTAMP; SECONDDATE; INTEGER; TINYINT;
 SMALLINT; BIGINT; REAL; DOUBLE; FLOAT; SMALLDECIMAL;
 DECIMAL; VARCHAR; NVARCHAR; CLOB; NCLOB;
 ALPHANUM; TEXT; SHORTTEXT; BLOB; VARBINARY;
};

And here is the reference (Page 36, SQL Data Type section)

You can use VARCHAR(1) or TINYINT instead.