Another year, another blog.

Seems like it’s about once a year that I launch a new blog.  Usually on or around Jan 1st.  No promises this year.  Just a new space to rant.

Enum in Propel

Propel does not support Enum as a schema.xml column.type attribute, because Enum is mysql-specific.

Instead set the column.sqlType attribute to ‘ENUM’, column.type attribute to VARCHAR, and column.size attribute to 32 (assuming that each member of your enum could adequately be represented as a varchar 32)

<column name="pgo_type" type="VARCHAR" size="32" required="true" sqlType="ENUM" />