title: Hibernate append table alias in query.
body: <p>I have this in my user.java:</p>
  
  <pre><code> @Entity
   @Table(name="users")
  
   public class Users_Model implements Serializable{
  
   @Id @GeneratedValue
   private Long id;   
   @ColumnTransformer(
          read="AES_DECRYPT(userName, 'Hf7p4u6e')",
          write="AES_ENCRYPT(?, 'Hf7p4u6e')")
   }
  </code></pre>
  
  <p>I used aes_decrypt to retrieve the values in my database which is encrypted. My problem is it's only decrypt the english characters but not the japanese or chinese characters. The output I get is :<code>Hello ����������</code> it should be: <code>Hello 한국어/조선말</code>.</p>
  
  <p>I tried to display the query and this is what I got:</p>
  
  <pre><code>select message_mo0_.id as id0_, CONVERT(AES_DECRYPT(message_mo0_.createdBy, 'Hf7p4u6e') message_mo0_.USING message_mo0_.utf8) as userName_, from users message_mo0_
  </code></pre>
  
  <p>As you can see it appends the table alias in my query in <code>using utf8</code> so everytime I get <code>error sql  syntax correct</code>. My question is there a way to tell the hibernate not to append table alias. I would like to generate a query which looks like this to where the <code>using utf8</code> is no appended table alias:</p>
  
  <pre><code>select message_mo0_.id as id0_, CONVERT(AES_DECRYPT(message_mo0_.createdBy, 'Hf7p4u6e') USING utf8) as userName_, from users message_mo0_ 
  </code></pre>
  
  <p>I've been stuck here for almost 4 days. Please help. Thank you in advance</p>