<?xml version="1.0" encoding="windows-1252"?>
<node id="623814" title="Re^2: A UTF8 round trip with MySQL" created="2007-06-28 03:53:32" updated="2007-06-27 23:53:32">
<type id="11">
note</type>
<author id="523944">
clinton</author>
<data>
<field name="doctext">
&lt;blockquote&gt;&lt;i&gt;
$data = fetch;&lt;br /&gt;
$data = decode_utf8 $data;
&lt;/i&gt;&lt;/blockquote&gt;

The bit you're missing here is deciding which data to decode, because of course you need to handle text and binary data differently. The latest [mod://DBD::mysql] drivers handle this automatically.&lt;p&gt;
Clint</field>
<field name="root_node">
620803</field>
<field name="parent_node">
623764</field>
</data>
</node>
