title: How to fake ENUM columns in the H2 database for play unit testing?
body: <p>I have a set of Play! unit tests that I have been running against an H2 database. I have added some enum columns to my model, and the tests now fail because of the sql statements used to create my model tables.</p>
  
  <p>The error message is:</p>
  
  <pre><code>14:42:10,435 ERROR ~ Unknown data type: "ENUM"; SQL statement:
  </code></pre>
  
  <p>Some searching shows that there are ways to emulate enums in H2 (eg: <a href="http://groups.google.com/group/h2-database/search?group=h2-database&amp;q=enum&amp;qt_g=Search+this+group" rel="nofollow">http://groups.google.com/group/h2-database/search?group=h2-database&amp;q=enum&amp;qt_g=Search+this+group</a>)</p>
  
  <p>Setting Play to use the H2Dialect for test mode does not fix the issue. It seems like the root cause is that H2 does not support enums, or maybe that the H2Dialect doesn't know about H2's pseudo-enums. </p>
  
  <p>Is there a way in Play to test models with enums in H2?</p>