title: Want Mybatis to insert booleans as Y,N, not 0,1
body: <p>I'm writing a class instance to a MySQL DB using MyBatis</p>
  
  <pre><code>// I have no control over how this java class is laid out -.-
  class Hello {
      boolean isFriendly
  }
  </code></pre>
  
  <p>my MyBatis Mapper looks like this</p>
  
  <pre><code>&lt;insert id="doHello" parameterType="Hello"&gt;
      insert into hello_table (
          is_friendly   --this is a varchar(1) btw
      )
      values (
        #{isFriendly}
      )
   &lt;/insert&gt;
  </code></pre>
  
  <p>The problem is it inserts the values into the DB as 0 or 1, but I need to have it as 'N' or 'Y'
  and I don't have the choice of modifying the java</p>
  
  <p>I'm trying to keep my code as minimal as possible and ideally would like to add stuff into the Mybatis Mapper</p>
  
  <p>I tried things like </p>
  
  <pre><code> #{isFriendly,jdbcType=Boolean}
  </code></pre>
  
  <p>but it didn't work</p>