Skip to main content
colinj205
colinj205
January 19, 2022
Question

TINYINT replaced by BIT in xsd?

  • January 19, 2022
  • 1 reply
  • 0 views

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

    1 reply

    harshitb6843
    harshitb6843
    January 19, 2022

    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

    Terms & ConditionsAccessibility statement