I'm currently building a small application with sqlite.
I'm having trouble adding single quotes to the data fields to be stored in my database.

I'm using C++ to build the application.
Is there any workaround to the problem of adding single quotes to a database. single quotes like this ' '
I know you can get around this by adding another single quote to it (two single quotes), but I thought this could be the result of some other reason which could be overidden.

Basically what happens is this.
II enter data into a text editor >>>> I push a button and that data is submitted to a table in a database >>> if there are any single quotes in the text (and not to single quotes together like this '') I get an error because apparently you can add single quotes to a database.

Is there a workaround for this?