Author Topic: Define a field as Tiny Int instead of Int (Read 384 times)

robinmitra · July 25, 2014, 08:32:06 am

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 · July 28, 2014, 06:59:38 am

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).

CiviCRM Community Forums (archive)

News:

Author Topic: Define a field as Tiny Int instead of Int (Read 384 times)

robinmitra

Define a field as Tiny Int instead of Int

Michael McAndrew

Re: Define a field as Tiny Int instead of Int