Define a field as Tiny Int instead of Int

[robinmitra]

Hi all

I'm building a CiviCRM extension, and want to define a field as tiny int (because the number would only ever be less than around 10), instead of int in an entity's DAO.

Since CRM_Utils_Type doesn't define tiny int as a constant, is it possible to achieve this in a standard way?

I believe I can define the field as tinyint in SQL but use int in my DAO but this is a bit inconsistent, and wanted to make sure that I wasn't missing anything.

Thanks
Robin

[Michael McAndrew]

Hey there,

I think the only place we use tiny int in civicrm / with DAO is for boolean.  my suggestion would be don't worry about the fact that it will only ever be small and just use INT. I doubt in will affect performance / memory usage (though obviously depends on your use case / maybe you have a reason to think it will be a big deal).