"Can't" and "Don't" use of ' in database, proper way

Databases
1

Hey, recently I got a message from a customer, he could not enter the following into my database:

Can’t stop falling in love.

Reason the ’ killed the input. So how do you guys/girls deal with that character. the '.
Do I change it to ´or ` instead, or what ?
Using sql with my valentina database, input from Standalone web app.

cheers.

2

Use Prepared Statements. This will not only solve your issue, but also lead to a more secure Database use: http://developer.xojo.com/userguide/sql-injection

3

Read up on “escaping characters”. But Prepared Statements automatically escape troublesome characters.

4

Thank you !