How to add Additional quote (') in Insert statement using QODBC

Problem Description:

I have exported the customer list from QB, and Now I want to insert these using the insert query. But some of them fail because of the apostrophe (').
How to deal with special characters like this.

Solutions:

I want to inform you that you can get an additional quote for your query.
For Example, If you want to add a customer whose name contains extra quotes, then you can insert the name using the below query:
Insert into customer (name) values ('Larry's Custom Invoice ')
The above question will create a customer entry named Larry's Custom Invoice.