title: Select json column using JPA native query with MemSql
body: <p>I have a table in a <code>MemSql</code> database which contains a column of type <code>JSON</code>. </p>
  
  <p>I am trying to execute the following query.</p>
  
  <pre><code>select tweet from tweets_json;
  </code></pre>
  
  <p>The <code>tweet</code> column is the <code>JSON</code> column. </p>
  
  <p>Here is the code I am using to execute this query. </p>
  
  <pre><code>public List&lt;String&gt; getTweets(){
      Query q = entityManager.createNativeQuery("select tweet from tweets_json");
      List&lt;String&gt; resultList = query.getResultList();
  }
  </code></pre>
  
  <p>I am expecting the result to be a list of strings and each string to represent the JSON. </p>
  
  <p>The problem is that I am getting the string converted to as a single <code>Character</code> object which contains only the first character of the JSON <code>{</code>.</p>
  
  <p>The result is always a list of Character with the open curly bracket symbol regardless the type of the list item I am using.</p>
  
  <p>I tried using <code>List&lt;Object[]&gt;</code>, <code>List&lt;String[]&gt;</code>, <code>List&lt;Object&gt;</code>, <code>List&lt;JsonElement&gt;</code> and all returing the same result. </p>
  
  <p>I even tried to not specify the type of the list elements and return just a List and the result still the same. </p>
  
  <p>How can I get the whole JSON and what is the root cause of this issue? </p>