title: jdbc how to insert mysql SET type?
body: <p>Hi
  I have a code for table creating:</p>
  
  <pre><code>create table clt (id bigint not null, sources set('A1', 'empty', 'A2', 'A3'), text varchar(50));
  </code></pre>
  
  <p>table was created successfully.</p>
  
  <p>now I'm trying to insert data:</p>
  
  <pre><code>java.sql.PreparedStatement stmt = null;
  String query = "insert into clt (id, sources, text) values (?, ?, ?)";
  stmt = conn.prepareStatement(query);
  int it = 0;
  stmt.setLong(++it, 25);
  stmt.setString(++it, "A1, A2");
  stmt.setString(++it, "some text data");
  stmt.executeUpdate();
  </code></pre>
  
  <p>and gettting an error :(
      exception: java.sql.SQLException: Data truncated for column 'sources' at row 1</p>
  
  <p>without <em>sources</em> everything is ok.
  where is my mistake?</p>
  
  <p>thank you.</p>