title: Set column collation charset for JPA
body: <p>I have a crusual question. MS SQL Server 2005 database with Latin collation stores a lot of data with non-Latin collation. I have no ability to change the collation, and the only way is to put <code>collate</code> in queries.</p>
  
  <p>When I use JPA, I get a wrong charset in strings. How can I tell JPA, to use a specific collation when It work with the specific  columns? I unsuccessfully looked for some annotation and tried to use  <code>collate</code>  in queries like </p>
  
  <p><code>SELECT t COLLATE Cyrillic_General_CI_AS FROM TXTTable t WHERE t.textid = :textid</code>.</p>
  
  <p>Please, help me!
  THANK YOU TOO MUCH!</p>