title: Error while executing SQL script but not when running individually
body: <p>I am running a script file using following command:</p>
  
  <pre><code>mysql -u root -p MyTable &lt; questions.sql
  </code></pre>
  
  <p>And getting following error:</p>
  
  <pre><code>ERROR 1366 (HY000) at line 8358: Incorrect string value: '\xD7 4 = ...' for column 'choiceA' at row 1
  </code></pre>
  
  <p>When I tried to debug, I found that this error was happening because I had  special characters like multiplication and divide mathematical symbols. After doing some Googling I found that the character encoding for my database should be UTF-8, I changed that too but still getting the same error. </p>
  
  <p>I am a little bit surprised that if I try to execute the same query manually in SQL prompt, it works fine!! Which means that my db encoding is correct.</p>
  
  <p>I am not able to figure out where can be the issue and seek some exert advice.</p>