title: ODBC connector support for utf8mb4 in MYSQL
body: <p>I have been stuck up in this scenario.</p>
  
  <p>My application is in C++ which connects to MySQL database 5.5.34 through MySQL odbc connector v5.2 Unicode Driver.</p>
  
  <p>My tables were using the character set and collation properties 'utf-8'. To insert supplementary unicode characters, i changed it via</p>
  
  <p>My table was initially created:</p>
  
  <pre><code>CREATE TABLE mytable (SAMPLECOLUMN text) ENGINE=InnoDB DEFAULTCHARSET=utf8;
  
  changed to,
  ALTER TABLE mytable CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
  </code></pre>
  
  <p>After this, I am able to directly (not through my app) insert the supplementary characters into the column holding 'TEXT' data type.</p>
  
  <p>The odbc connector crashes when it encounters supplementary characters.</p>
  
  <p>The following are some of my <strong>my.ini</strong> configurations.</p>
  
  <pre><code>[mysql]
  default-character-set=utf8
  
  [mysqld]
  character-set-server=utf8
  default-storage-engine=INNODB
  </code></pre>
  
  <p>The query that i am trying to insert:</p>
  
  <pre><code>INSERT INTO mytable (SAMPLECOLUMN) VALUES ("乕乭乺丕");
  </code></pre>
  
  <p>any pointers/heads up would be great.</p>
  
  <p>Also, tried using v5.3 Unicode MYSQL odbc connector and v1.0.5 MariaDB ODBC connector, still the same.</p>
  
  <p>Thanks in advance.</p>