title: Unsupported SQL Type 1111 when passing String to a VARCHAR field
body: <p>I have been smashing my head against this for a while now. </p>
  
  <p>I am using iBatis with my JAVA code to run Stored Proc residing in Sybase DB. </p>
  
  <p>Stored procedure is expecting some parameters. few of them are declared as <code>VARCHAR (6)</code></p>
  
  <p>So in my iBatis mapping i did the following for those parameters. </p>
  
  <pre><code>&lt;parameter property="searchUserId" jdbcType="String" javaType="java.lang.String" mode="IN"/&gt;
  </code></pre>
  
  <p>However, when I do this I get the following error. </p>
  
  <pre><code>--- Check the statement (update procedure failed).  
  --- Cause: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 1111.
  Caused by: java.sql.SQLException: JZ006: Caught IOException: java.io.IOException: JZ0SL: Unsupported SQL type 1111.
  </code></pre>
  
  <p>So I changed my mapping to following:</p>
  
  <pre><code>&lt;parameter property="searchUserId" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/&gt;
  </code></pre>
  
  <p>which got rid of the error above, however, now the parameter <code>searchUserId</code> is getting value of <code>null</code> passed into the SP.  I know for sure that from my java code I am NOT passing <code>null</code>. </p>
  
  <p>Has someone faced this issue? what should I change my mapping to??</p>