Encoding Issue

[Tj Krause]

We recently upgraded our self hosted instance from 2016-04-23 to the most recent version on 9/27. Upon doing so, the following symbol showed up in quite a number of places in our course content primarily quizzes. We tried exporting the database and converting between UTF-8 and ASCII as well as ISO-8859-1. We also tried replacing the character with nothing using the sed command on the SQL dump. When we run the following SQL query, we receive no results however our courses still show with invalid characters in them. We also tried clearing the Redis cache with redis-cli flushall. Screen shot of the quiz content is below as well as the SQL query and our table listing. 

Seems that Ruby is changing it somewhere when it shouldn't be.

Anyone run into this before or have any suggestions?

Â

SELECT *

FROM quiz_questions

WHERE question_data like '%Â%';