title: "SQLiteDatabase.insert(TABLE_NAME,null,ContentValues);" showing "datatype mismatch" error
body: <p>I know basics about SQLite .When i was working on Reverse engineering of SQLite for android development--> Even i have copied most of the code and paste it in mine , my app show error in logcat about data mismatch.</p>
  
  <p>(The error is in setNotes method down)</p>
  
  <pre><code>public class DatabaseHelper extends SQLiteOpenHelper {
  
  
  
  public DatabaseHelper(Context c){
      super(c,"Notes_Database",null,1);
  }
  @Override
  public void onCreate(SQLiteDatabase db) {
      db.execSQL(Note.CREATE_TABLE);
  
  }
  
  
  
  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  
  
      db.execSQL("DROP TABLE IF EXISTS " + Note.TABLE_NAME);
      onCreate(db);
  
  
  
  
  }
  public long setNotes(String wordv,String reversev){
      SQLiteDatabase db=this.getWritableDatabase();
      ContentValues values=new ContentValues();
      values.put("Word",wordv);
      values.put("Reverse",reversev);
  
      //This below line where the Error occurs.
      long id=db.insert(Note.TABLE_NAME,null,values);//&lt;--
  
  
      db.close();
      return id;
  }
  </code></pre>
  
  <p>My table name is :</p>
  
  <pre><code>public static final String CREATE_TABLE =
          "CREATE TABLE " + TABLE_NAME + "("
                  + "Word" + " TEXT,"
                  + "Reverse" + " TEXT"+")";
  </code></pre>
  
  <p>And Here is My Error(That is "<strong><em>[INSERT INTO notes(Reverse,Word) VALUES (?,?)] datatype mismatch"</em></strong>) :-(</p>
  
  <pre><code>    &gt; 2019-04-14 20:52:05.404 9597-9597/com.example.sqlwithjava E/SQLiteLog: (20) statement aborts at 5: ***[INSERT INTO notes(Reverse,Word) VALUES (?,?)] datatype mismatch***
  
  
  
  2019-04-14 20:52:05.406 9597-9597/com.example.sqlwithjava E/SQLiteDatabase: Error inserting Reverse=gfdhg Word=ghdfg
          android.database.sqlite.SQLiteDatatypeMismatchException: datatype mismatch (code 20)
              at android.database.sqlite.SQLiteConnection.nativeExecuteForLastInsertedRowId(Native Method)
              at android.database.sqlite.SQLiteConnection.executeForLastInsertedRowId(SQLiteConnection.java:782)
              at android.database.sqlite.SQLiteSession.executeForLastInsertedRowId(SQLiteSession.java:788)
              at android.database.sqlite.SQLiteStatement.executeInsert(SQLiteStatement.java:86)
              at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1474)
              at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1343)
              at com.example.sqlwithjava.DatabaseHelper.setNotes(DatabaseHelper.java:47)
              at com.example.sqlwithjava.MainActivity.ReverseText(MainActivity.java:30)
              at java.lang.reflect.Method.invoke(Native Method)
              at android.support.v7.app.AppCompatViewInflater$DeclaredOnClickListener.onClick(AppCompatViewInflater.java:385)
              at android.view.View.performClick(View.java:5610)
              at android.view.View$PerformClick.run(View.java:22265)
              at android.os.Handler.handleCallback(Handler.java:751)
              at android.os.Handler.dispatchMessage(Handler.java:95)
              at android.os.Looper.loop(Looper.java:154)
              at android.app.ActivityThread.main(ActivityThread.java:6077)
              at java.lang.reflect.Method.invoke(Native Method)
              at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:866)
              at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:756)
  </code></pre>
  
  <p>And Thanks in advance.</p>