I have a form with several textarea fields. If the user enters a contraction such as "doesn't:", the entry gets cut off at the apostrophe. Obviously, the apostrophe is not being escaped properly when stored to MySQL. I'm not seeing a setting to fix this and I'm actually very surprised this is an issue given that this is a very well known issue with MySQL databases.
How do I allow my user to enter apostrophes without having to manually escape them?