title: Strange symbols in SQLite text field
body: <p>I have a simple SQLite database where data (names) is added with a C# application. The names usually get copied and pasted from .pdf files. I found out that sometimes copying a name from .pdf generates some weird symbols. During browsing data with SQLite DB Browser I saw that some records in my database have things mingled in between like 'DC3', 'FS', 'US' and so on:</p>
  <p><a href="https://i.stack.imgur.com/C2W1Y.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/C2W1Y.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/kRhFY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kRhFY.png" alt="enter image description here" /></a></p>
  <p>This messes with 'WHERE' clause in my queries, for example the following query would yield 0 results:</p>
  <pre><code>SELECT Id FROM tblPerson WHERE Name = 'Alex Denelgo'; 
  </code></pre>
  <p>Can someone explain what these symbols are and how can I write query to find all the &quot;corrupted&quot; name records? I can't go one by one manually with browser since the data already contains thousands of different names.</p>