title: CallableStatement setString - Unsupported character(s)?
body: <p>I have a Java application decoding a UTF-8 encoded <code>String</code> received over the wire and saving it to a <code>varchar</code> column in my database (SQL Server 2000).  I am saving the record using JDBC's <code>CallableStatement</code> (calling the <code>setString</code> method to set the parameter for this column).</p>
  
  <p>The problem I'm seeing is that a particular <code>String</code> has been written that contains ASCII value 0 (<code>NUL</code>).  This suggests to me that SQL server cannot represent a particular Unicode character and the JDBC driver has decided to substitute in ASCII value 0, although I may be wrong.</p>
  
  <ul>
  <li>Has anyone else encountered this problem?</li>
  <li>Is there a mechanism I can use to cause the <code>CallableStatement</code> call to fail in this situation? </li>
  </ul>
  
  <p>Ideally I would like to guarantee that data has been saved exactly as specified, or else "fail fast".</p>
  
  <p>My database character set is <code>Latin1_General_AS_CS</code>.</p>
  
  <p>Thanks in advance.</p>