title: SQL tables using VARCHAR with UTF8 (with respect to multi byte character length)
body: <p>Like in Oracle <code>VARCHAR( 60 CHAR )</code> I would like to specify a varchar field with variable length depending on the inserted characters.</p>
  
  <p>for example: </p>
  
  <pre><code>create table X (text varchar(3))
  insert into X (text) VALUES ('äöü')
  </code></pre>
  
  <p>Should be possible (with UTF8 as the default charset of the database).</p>
  
  <p>On DB2 I got this Error: <code>DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001</code>
   (Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small.)</p>
  
  <p>I'm looking for solutions for DB2, MsSql, MySql, Hypersonic.</p>