Archive for November, 2008

Enum in Propel

Posted November 25, 2008 * Comments(0)

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" />