title: Set PRAGMA encoding ="UTF-16" for main database in sqlite
body: <p>I read that it is not possible to change the text encoding of a database after it has been created and any attempt to do so will be silently ignored.(from <a href="http://sqlite.org/pragma.html#pragma_user_version" rel="nofollow noreferrer">here</a>)</p>
  
  <p>Frome <a href="https://stackoverflow.com/questions/18890895/sqlite-error-for-creating-database?rq=1">this post</a>, to create main database,say 'databasename.db' in SQLite, we have to type following in command prompt :</p>
  
  <blockquote>
    <p>sqlite3 databasename.db</p>
  </blockquote>
  
  <p>which creates the database and displays sqlite shell as :</p>
  
  <pre><code>C:\Documents and Settings\Administrator&gt;sqlite3 AudioData.db
  SQLite version 3.7.11 2012-03-20 11:35:50
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite&gt;
  </code></pre>
  
  <p>In this case, how to set PRAGMA encoding ? How can I give PRAGMA command before create database command since the sqlite shell starts after create database command??
  Thanks in advance!</p>