title: Unicode problem Django-Python-URLLIB-MySQL
body: <p>I am fetching a webpage (<a href="http://autoweek.com" rel="nofollow noreferrer">http://autoweek.com</a>) and trying to process it but getting encoding error. Autoweek declares "iso-8859-1" encoding and has the word "Nürburgring" (u with umlaut)</p>
  
  <p>I do:  </p>
  
  <pre><code># -*- encoding: utf-8 -*-
  import urllib
  webpage = urllib.urlopen(feed.crawl_url).read()
  webpage.decode("utf-8")
  </code></pre>
  
  <p>it gives me the following error:</p>
  
  <pre><code>'utf8' codec can't decode bytes in position 7768-7773: unsupported Unicode code range"
  </code></pre>
  
  <p>if I bypass .decode step and do some parsing with lxml library, it raises an error when I am saving parsed title to database:</p>
  
  <pre><code>'utf8' codec can't decode bytes in position 45-50: unsupported Unicode code range
  </code></pre>
  
  <p>My database has character set utf8 and collation utf-general-ci</p>
  
  <p>My settings:<br>
   Django<br>
   Python 2.4.3<br>
   MySQL 5.0.22<br>
   MySQL-python 1.2.1<br>
   mod_python 3.2.8  </p>