title: How can I handle unicode with Perl's DBI?
body: <p>My <a href="http://edward.de.leau.net/wordpress-23-compatible-wordpress-delicious-daily-synchronization-script-20071114.html" rel="noreferrer">delicious-to-wp perl script</a> works but gives for all "weird" characters even weirder output.
  So I tried </p>
  
  <pre><code>$description = decode_utf8( $description ); 
  </code></pre>
  
  <p>but that doesnt make a difference. I would like e.g.  “go live” to become “go live” and not â€œgo liveâ€  How can I handle unicode in Perl so that this works?</p>
  
  <p>UPDATE: I found the problem was to set utf of DBI I had to set in Perl:</p>
  
  <pre><code>my $sql = qq{SET NAMES 'utf8';};
  $dbh-&gt;do($sql);
  </code></pre>
  
  <p>That was the part that I had to set, tricky. Thanks!</p>