hi
I'm having problems with the wrong kind of single quotes
in the db are a lot of short text strings that have been copied and pasted from a Word document - any time there's a single quote it's a ’ and not a standard single quote
this is causing problems when i compare it to user input that contains standard single quotes
when i compare the two strings they are not equal
is there any way i can convert the ’ quotes to ' quotes when i get the strings from the db ?