title: How to get table names using sqlite3 through python?
body: <p>I have a problem to get data from the sqlite3 database. I can't find out the names of tables and their encoding. When I open DB through sqlitebrowser names were just unreadable characters.
  Connection to DB is fine.</p>
  
  <pre><code>conn = sqlite3.connect('my.db')
  conn_cursor = conn.cursor()
  conn.text_factory = str
  </code></pre>
  
  <p>But how can I get the names of tables and their encoding?</p>