title: Column data type
body: <p>I have an application that has to load various H2 database files for different tasks at runtime and must be able to verify that the loaded DB conforms to a predefined schema. By this I mean that I query the information schema to check whether specific tables are present and whether these tables contain properly defined columns (eg data type, length, indexes etc).</p>
  
  <p>My question is concerning H2's internal data types and how they map to values listed in <code>INFORMATION_SCHEMA.COLUMNS</code>. For example am I correct that the data_type column in this table properly reflects a columns data type as given during table creation eg</p>
  
  <pre><code>CREATE TABLE test (id int primary key, some_string varchar(32) ... )
  </code></pre>
  
  <p>the int is mapped to a data type of 4? Is there a listing of the mappings of the data types to internal codes and do these ever change?</p>