TINYINT replaced by BIT in xsd?

Question

I couldn't get my DataStore to to republish a DataType association that's been around for a year.

Finally, I created a new DataType from the same view and compared the downloaded xsd's

Old one:

<xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="TINYINT")</xsd:appinfo>

New one:
<xsd:appinfo source="appian.jpa">@Column(name="isMultiplePlan", columnDefinition="BIT")</xsd:appinfo>

The view hasn't changed. It's still a TINYINT(1).

Is BIT new with the MariaDB version?

Thanks,

Colin

Harshit Bumb (Appyzie) · Accepted Answer

Hi Colin, 
 That might be the case. But BIT is always a better option than TINYINT as the BIT will only store 1 or 0. I have personally only used BIT for any boolean flag on the DB side and then map it to boolean on the Appian side. 
 Thanks, Harshit