title: MySql: Incorrect string value: '\xC5\x9Fe' for column
body: <p>I have a stored procedure and it has a string parameter. When I call with word which contains some special chars like 'ş' or 'ğ' it returns <code>Error Code: 1366. Incorrect string value: '\xC5\x9Fe' for column 'personalNames' at row 1 . But when I call with without this special chars everything is ok.
  </code></p>
  
  <p>Here is my a part of my sp :</p>
  
  <pre><code>IF personalNames != '' THEN
      SET personalNames = LOWER(personalNames);
      SET @WherePart = CONCAT(@WherePart,' AND LOWER(per.Name) LIKE "%',personalNames,'%"');
  </code></pre>
  
  <p>Do you have any suggestion?</p>