How to properly prepare Strings for SQLite insertion in Android?
===

So as I was learning Android, I got much advice on how to use `ContentProvider` and how to insert things correctly with that using `SqliteDatabase`. Now I have an error that makes no sense, at least with what everything everyone was telling me. The error is this:

    android.database.sqlite.SQLiteException: near "s": syntax error:
    while compiling: SELECT * FROM events WHERE time_stamp='07/21/2012 2:59:03 PM' AND
    event='Test This's'

Everything works fine as long as `'` doesn't appear anywhere. I know why because it needs to be escaped. But this doesn't make sense because everyone has been telling me to not use raw queries but rather use the provided bindings methods if that even made sense. Let me provide what my example is:

    ContentValues newValues = new ContentValues();
    //put stuff in newValues
    Long success = database.insert("events_info", null, newValues);

From what I have been able to understand, why should I need to escape this since its suppose to bind it!? Unless this only applies to the other methods like `query()` and `update()`. In either case I am hoping someone to shed some light on the proper practice in preparing Strings for SQLite insertion in Android. Thank you in advance.