BCP is failing with weird characters in column value
<p>We are trying to export a BCP file to our SQL server table but it is constantly failing in some rows. One common problem we saw with the rows was they have weird characters in them. Example below:</p>

<p>This is the BCP (out of OP's comment below):</p>

<pre><code>bcp risk_models.nis.EE_CSV_48 in {} -c -k -q -S sqlserver -U username -P password -h TABLOCK -b 500
</code></pre>

<p>And this is the weird output</p>

<pre><code>  SAMPLE ROW 1 ▒
  SAMPLE ROW 2 ▒
</code></pre>

<p>Now the character at the end is our suspect but this character is converted into ? during the bcp load. What's more weird is that if we just load these rows without the others( by others I mean the ones without the weird character), the load is successful even with the weird character. </p>

<p>Can someone shed some light on what's wrong?</p>