title: Hsqldb table encoding
body: <p>How do I set the character encoding for a specific table? E.g:</p>
  
  <pre>
  CREATE TABLE COMMENTS (
      ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1) NOT NULL,
      TXT LONGVARCHAR,
      PRIMARY KEY (ID)
  )
  </pre>
  
  <p>By default it's encoded as ASCII but I'd rather use UTF-8 for this one table.</p>