title: Extra "hidden" characters messing with equals test in SQL
body: <p>I am doing a database (Oracle) migration validation and I am writing scripts to make sure the target matches the source. My script is returning values that, when you look at them, look equal. However, they are not.</p>
  
  <p>For instance, the target has <code>PREAPPLICANT</code> and the source has <code>PREAPPLICANT</code>. When you look at them in text, they look fine. But when I converted them to hex, it shows <code>50 52 45 41 50 50 4c 49 43 41 4e 54</code> for the target and <code>50 52 45 96 41 50 50 4c 49 43 41 4e 54</code> for the source. So there is an extra <code>96</code> in the hex. </p>
  
  <p><a href="https://i.stack.imgur.com/65OMY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/65OMY.png" alt="enter image description here"></a></p>
  
  <p>So, my questions are:</p>
  
  <ol>
  <li>What is the <code>96</code> char?</li>
  <li>Would you say that the target has incorrect data because it did not bring the char over? I realize this question may be a little subjective, but I'm asking it from the standpoint of "what is this character and how did it get here?"</li>
  <li>Is there a way to ignore this character in the SQL script so that the equality check passes? (do I want the equality to pass or fail here?)</li>
  </ol>