title: Deal with new line character “\n” in Sqlite database using Python?
body: <p>I have a Sqlite database named test.db, which contains two tables with structures like this:</p>
  
  <p>Table1: ID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(500), Color varchar(500)</p>
  
  <p>Table2: ID INTEGER PRIMARY KEY AUTOINCREMENT, Name varchar(500), Smell varchar(500)</p>
  
  <p>I am trying to join two tables using the following code</p>
  
  <pre><code>con = sqlite3.connect('test.db') 
  with con: 
    cur = con.cursor()
    cur.execute("SELECT Color, Smell FROM Table1, Table2 WHERE Table1.Name = Table2.Name") 
  </code></pre>
  
  <p>However, I failed because Table1.Name has invisible new line character “\n” inserted, while Table2.Name doesn’t, so the WHERE clause doesn’t work.</p>
  
  <p>Is there a way to modify the SELECT statement a little bit so that Table1.Name = Table2.Name will work? Or do I have to regenerate Table1 to remove “\n”, but I don’t know how?</p>