TAP - Supported datatypes

[Stephen Lloyd]

Hi,

TLDR: Are Booleans acceptable data types in TAP and if not, should they be converted to another data type?

I'm wondering if anyone can assist with either pointing me to the correct documentation containing a definitive list of supported data types for TAP please?

I'm currently looking at the Vollt libraries and there seems to be a list of validated types<https://github.com/gmantele/vollt/blob/master/src/adql/db/DBType.java> SMALLINT, INTEGER, BIGINT, REAL, DOUBLE, BINARY, VARBINARY, CHAR, VARCHAR, BLOB, CLOB, TIMESTAMP, POINT, CIRCLE, POLYGON, REGION, UNKNOWN, UKNOWN_NUMERIC but no BOOLEAN. I have existing database tables/columns that have BOOLEAN data types but they get converted to UNKNOWN at runtime due to the validation in Vollt.
Should TAP support BOOLEAN or should it be converted to say SMALLINT (as a 0/1)?

Thanks,
Stephen Lloyd

Research Software Engineer
University of Manchester
UKSRC

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ivoa.net/pipermail/dal/attachments/20241107/dcda25ff/attachment.htm>