title: Insert Sqlite string with brackets / special characters
body: <p>for a quiz android app I made a sqlite database with categories names. When I run a select query like this : </p>
  
  <pre><code>select * from QuestionBank where category = 'Adjektiv - Deklination (''der kalte Kaffee/ein kalter Kaffee/kalter Kaffee'')'
  </code></pre>
  
  <p>I get (with DB Browser for Sqlite) : </p>
  
  <pre><code>0 rows returned in 70ms from: select * from QuestionBank where category = 'Adjektiv - Deklination (''der kalte Kaffee/ein kalter Kaffee/kalter Kaffee'')'
  </code></pre>
  
  <p>also with " instead of ' ' it give the same result </p>
  
  <pre><code> select * from QuestionBank where category = 'Adjektiv - Deklination ("der kalte Kaffee/ein kalter Kaffee/kalter Kaffee")'
  
  0 rows returned in 72ms from: select * from QuestionBank where category = 'Adjektiv - Deklination ("der kalte Kaffee/ein kalter Kaffee/kalter Kaffee")'
  </code></pre>
  
  <p>how to deal with that problem ? in MS-Sql I would just make it a VARCHAR with N but how to make it here ? </p>
  
  <p>here is a screenshot for my DB.</p>
  
  <p><a href="https://i.stack.imgur.com/ULbmr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ULbmr.png" alt="enter image description here"></a></p>
  
  <p>Thank you for your time. </p>