title: 1366 mysql incorrect string value for Zhuyin Fuhao
body: <p>The "Incorrect string value error" is raised from MySQLdb. </p>
  
  <pre><code>_mysql_exceptions.OperationalError: (1366, "Incorrect string value: '\\xF0\\xA0\
  \x84\\x8E\\xE2\\x8B...' for column 'from_url' at row 1")
  </code></pre>
  
  <p>But I already set both the connection charset and from url encoding to utf8. It works without problem for millions for records previously. </p>
  
  <p>the value which will cause exception:
  I think the issue is related to the special character u'\U0002010e' (a chinese special character "ㄋ")</p>
  
  <pre><code>u'http://www.ettoday.net/news/20120227/27879.htm?fb_action_ids=305328666231772&amp;
  fb_action_types=og.likes&amp;fb_source=aggregation&amp;fb_aggregation_id=288381481237582
   \u7c89\u53ef\u611b\U0002010e\u22ef http://www.ettoday.net/news/20120221/26254.h
  tm?fb_action_ids=305330026231636&amp;fb_action_types=og.likes&amp;fb_source=aggregation&amp;
  fb_aggregation_id=288381481237582 \u597d\u840c\u53c8\u22ef'
  </code></pre>
  
  <p>but this character can be encoded as utf8 in python as well.</p>
  
  <pre><code>&gt;&gt;&gt; u'\U0002010e'.encode('utf8')
  '\xf0\xa0\x84\x8e'
  </code></pre>
  
  <p>So why MySQL cannot accept this character?</p>