title: Stored Procedure doesn't return any result as output but query works fine
body: <p>Why this stored procedure doesn't return any result</p>
  
  <pre><code>CREATE PROCEDURE `sp_location_selectAllByTermAutoComplete`(
  IN _term VARCHAR(99))
  BEGIN
  
      SELECT
          `title` AS `value`,
          `keyword` AS `label`,
          `city_id`,
          `id` AS `locationtitle_id`
      FROM `locationtitle`
      WHERE
          MATCH(`keyword`) AGAINST(_term  IN BOOLEAN MODE)
      ORDER BY MATCH(`keyword`) AGAINST(_term  IN BOOLEAN MODE) DESC
      LIMIT 0, 10
  ;END//
  </code></pre>
  
  <p>But this one returned</p>
  
  <pre><code>    SELECT
          `title` AS `value`,
          `keyword` AS `label`,
          `city_id`,
          `id` AS `locationtitle_id`
      FROM `locationtitle`
      WHERE
          MATCH(`keyword`) AGAINST('+NEW*'  IN BOOLEAN MODE)
      ORDER BY MATCH(`keyword`) AGAINST('+NEW*'  IN BOOLEAN MODE) DESC
      LIMIT 0, 10
  </code></pre>
  
  <p>Both of the input parameters are same as other.</p>
  
  <p>I have other stored procedure and they works fine.</p>
  
  <p>I'm using <code>PDO</code> to execute my stored procedure.</p>
  
  <p>I never used <code>OUT</code> in my stored procedure and no experience how to use it.</p>
  
  <p>I have tested the stored procedure in my localhost and works fine, but i don't know why it doesn't works on my server?</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I found my what is my problem.</p>
  
  <p>When i call a procedure that have <code>VARCHAR</code> as input parameter, string characters change to <code>?</code> (question sign).</p>
  
  <p>My database collation is <strong>UTF-8</strong> and any table are too</p>
  
  <p>And i added pdo utf-8 driver but i don't know why it doesn't work</p>
  
  <p>Even i cant call stored procedure in phpMyAdmin</p>