I'm having a problem with single quotes and storing it in postgresql from a textarea in a form. When I type directly in the text box and use single quotes, everything works fine because I use stripslashes.
However, when I copy and paste from MSWord, the following is stored in the database:
For instance, the word today's is stored as today\x92s.
Stripslashes and addslashes don't work for word documents.
When I query the database and display the textarea which I just had stored, it seems that Internet Explorer automatically removes \x92s and substitutes it with the single quotes. However, netscape displays it as today?s.
Is there anyway to parse for this problem so that I can store single quote text in postgresql without the\x92s
I appreciate your help.