I wrote a set of perl scripts that takes input from a web form for and saves
the information to the Mysql database.
The scripts works perfect except when there is a word with an apostrophe
example "don't" the INSERT command does not complain but nothing gets saved
to the database. The problem does not occur if I try to insert manually by
connecting to mysql so most likely it is happening from the PERL DBI module.
I am using Mysql version 3.22.32 and just upgrade to DBI-1.13.
Any help is much appreciated.