title: How can I replace a character from which I only have the unicode representation?
body: <p>I have a string that when displayed in Notepad++ reads:</p>
  
  <pre><code>App.xEFxBFxBF35
  </code></pre>
  
  <p>The tocken    EFxBFxBF seams to be some UTF entity that some applications cant handle (for me its redshift).</p>
  
  <p>In Notepad the string reads as </p>
  
  <pre><code>App.35
  </code></pre>
  
  <p>How can I remove this entity from a string in c#?</p>
  
  <p>EDIT</p>
  
  <p>In visual studio the string shows in the debugger as</p>
  
  <pre><code>"App.\uffff35"
  </code></pre>
  
  <p><strong>EDIT 1</strong></p>
  
  <p>At the end it turned out that the column needed to have its size doubled when I inserted non latin characters.</p>
  
  <p>I created the redshift table by looking at the character length of the columns in sql server and directly used that number for the columns in redshift. That was for languages with latin characters, but not with non latin characters.</p>
  
  <p>I found the different length by this  redshift query.</p>
  
  <pre><code>select  bit_length('M');
  select  bit_length('Б');
  select  bit_length('Ö');
  </code></pre>
  
  <p>Gives back 8,16,16</p>