title: How to insert a new line ("\n") character in SQLite?
body: <p>While trying to insert something like: </p>
  
  <pre><code>"Hello\nWorld"
  </code></pre>
  
  <p>SQLite throws error something like:</p>
  
  <blockquote>
    <p>Message: unrecognized token: "'Hello";"  (also few other errors)</p>
  </blockquote>
  
  <p>Even though I convert above string to <code>"Hello''\nWorld"</code> or <code>"Hello\"\n\"World"</code>, these escape characters sequences don't work in this case.  </p>
  
  <p>Currently using C++ language, I am inserting this column like any other simple string columns. I tried above escape sequence (even though I read in internet that, they don't work with <code>\n</code>).   </p>
  
  <p>How to insert new line and other such special characters in SQLite DB?</p>