spouse�s

SELECT DUMP(the_column)
  FROM xxx
 WHERE xxx

SELECT DUMP(<column with weird character>, 1016)
FROM <your table>
WHERE <column with weird character> like '%spouse%';

UPDATE <table>
    set <column with offending character>
            = REGEX_REPLACE(<column with offending character>,
                            "<character code of �>",
                            "'")
WHERE regex_like(<column with offending character>,"<character code of �>");

INSERT (<normal table columns>,...,<column with offending character>) INTO <table>
SELECT <all normal columns>, REGEX_REPLACE(<column with offending character>,
                             "092",
                             "027")  -- for ASCII/ISO-8859-1 apostrophe
FROM <table>
WHERE regex_like(<column with offending character>,"092");

DELETE FROM <table> WHERE regex_like(<column with offending character>,"092");