title: How to insert decimals. ex(12.5$) in Sqlite table
body: <p>I'm using python and sqlite to create a storage management program and I've encountered a product that has the price of 12.5$. but the program doesn't accept the entry. The column that has this entry is assigned an INTEGER type. What type should it be changed to so it accepts float/decimal type. </p>
  
  <p>When I tried to run it through the command line it gave me this error:</p>
  
  <pre><code>File "stores.pyw", line 1850, in submit
  'Total_Buying_Pricev': 
  get_value(Unit_Buying_Pricev)*get_value(Incomingvariable),
  TypeError: unsupported operand type(s) for *: 'NoneType' and 'int'
  </code></pre>
  
  <p>Unit_Buying_Pricev is a textbox in tkinter. same is Incomingvariable.
  The decimal is in the Unit_Buying_Price entry and I think this is the problem. the program doesn't accept the entry of this box and so it is considered none type or that's what I think.</p>
  
  <p>the get_value function looks like this :</p>
  
  <pre><code>def get_value(Entry_widget):
      value = Entry_widget.get()
      try:
          return int(value)
      except ValueError:
          return None
  </code></pre>
  
  <p>Note that this is going to be multiplied and summed so it can't be TEXT or DATE or BLOB for example.</p>