title: sqlite InterfaceError: Error binding parameter 0 - probably unsupported type
body: <p>I am using sqlite3 python modules and th following code returns the error </p>
  
  <blockquote>
    <p>InterfaceError: Error binding parameter 0 - probably unsupported type</p>
  </blockquote>
  
  <p>Note I have already tried with normal (non unicode) strings and the result is the same</p>
  
  <pre><code># get database cursor
  cur = dbConnection.cursor()
  
  # create table for prices
  cur.execute( """
     create table if not exists
     prices( time text,                     
             mid integer, 
             exid text,
             selid integer,                     
             priceone real,
             sometext text,
             price2 real,
             primary key (time, mid, exid, selid, priceone)
             foreign key (time, mid, exid, selid) references selection(time, mid, exid,selid) )""" )
  
  #insert price
  tuple  = (u'20120228153239788135', 104982590, 1, 4764315, 1.99, u'B', 0.07)
  cur.execute( "insert into prices values (?,?,?,?,?,?,?)", tuple)
  </code></pre>