title: How to insert double and float values to sqlite?
body: <p>Following is my db creation code.</p>
  
  <pre><code>@Override
      public void onCreate(SQLiteDatabase db) {
          db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + 
                  _ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " + 
                  TIME + " INTEGER, " + 
                  LONGI + " TEXT, "+
                  LATI + " TEXT, "+
                  SPEED + " TEXT, "+
                  ACCU + " TEXT);");
      }
  </code></pre>
  
  <p>Then here goes the adding an data point code</p>
  
  <pre><code>private void addGeoDataEntry(double logi, double lati, float speed, float accu) {
          SQLiteDatabase db = gpsDataHelper.getWritableDatabase();
          ContentValues values = new ContentValues();
          values.put(TIME, System.currentTimeMillis());
          values.put(LONGI, logi+"");
          values.put(LATI, lati+"");
          values.put(SPEED, speed+"");
          values.put(ACCU, accu+"");
          db.insertOrThrow(TABLE_NAME, null, values);
      }
  </code></pre>
  
  <p>when I call </p>
  
  <pre><code>addGeoDataEntry(10.0,11.0,3.0f,1.1f);
  </code></pre>
  
  <p>it gives the following error. How to fix this?</p>
  
  <pre><code>03-14 13:57:26.910: I/Database(27910): sqlite returned: error code = 1, msg = near "1.0": syntax error
  </code></pre>