title: MYSQL not recognizing some special characters
body: <p>Why won't mysql recognize é and a lot more characters including em dash (—) ?? This is driving me nuts. i keep getting such errors like <code>Incorrect string value: '\xE9' for column</code> 
  I am using mysql 5.5.6 , my tables are innodb and using collation utf8-default collation.
  I don't know if this is important but I am doing bulk insert from a csv file which contains special characters and my fields are of type TEXT</p>