The following query is supposed to match all comments containing ‘testa’, but it matches ‘testä’, as shown below: How to do an exact match only for the string ‘testa’, so that it doesn’t show results for its matching special character? Answer I think I have a solution for you. You can use convert(column_name using latin1). Please check my code below=>