title: How to specify data type when using native SQL query?
body: <p>I am using hibernate. I have written native SQL query and I would like to specify data type of one of the column as below.</p>
  
  <pre><code>sqlQuery.addScalar("NAME", STRING);
  </code></pre>
  
  <p>I am querying 5 columns and <code>ID</code> is one of the column among them. But if I use <code>addScalar</code>, it is not returning all the columns and is returning only <code>NAME</code>. the reason why I am specifying the column type is <code>NAME</code> column is of <code>CHAR(10)</code> in table but I want <code>String</code> type. How can I specify the datatype and get all the columns?</p>