title: Hibernate postgresql/hsqldb TEXT column incompatibility problem
body: <p>I have a problem using Hibernate and PostgreSQL for production and HSQLDB for testing.<br />
  I am using top-down approach letting Hibernate create database schema.<br />
  I am also using annotations; mapping part of hibernate.cfg.xml only contains lines like<br />
  <code>&lt;mapping class="package.subpackage.ClassName" /&gt;</code> <br />
  Hibernate defaults String variables to character varying(255) on PostgreSQL which is not sufficient for me in some cases, so I have to redefine some columns manually using <br />
  <code>@Column(columnDefinition = "TEXT")</code>. <br />
  But, TEXT type is invalid for HSQLDB, so those tables can not be created. <br /> <br />
  Can anyone help to solve this?</p>