perlquestion
ultranerds
Hi,
<p>First of all, I've read perlunitut, and also the page linked to from it (regarding UTF8). From my understanding, what I gotta do is:</p>
<code>use Encode;
my $data = decode('UTF-8', $IN->param("data"));</code>
<p>...process it here</p>
<code>$data = decode('UTF-8', $data);</code>
<p>In my actual example script, I've used:</p>
<code>map {
$cat_add->{$_} = encode("UTF-8",$cat_add->{$_} );
} keys %$cat_add;</code>
(my script is creating a hash, which is getting passed into a DB module).
The output of the script seems ok - but for some reason its broken in phpMyAdmin :/
<code>Adding: Agricultura/Fumigación Aérea
$VAR1 = { 'FatherID' => '75321', 'Full_Name_Flat' => 'agricultura/fumigacion aerea', 'Full_Name' => 'Agricultura/Fumigación Aérea', 'Name_English' => 'Aerial fumigation', 'Name' => 'Fumigación Aérea', 'CatDepth' => '0' }; Done...</code>
...and in phpmyadmin:
<code>75321 Agricultura 0 0 0 Agricultura 0 0 No No NULL 2012-09-04 03:11:10 0 Agriculture agricultura
75322 Fumigación Aérea 75321 75321 1 Agricultura/Fumigación Aérea 0 0 No No NULL 2012-09-04 03:11:10 0 Aerial fumigation agricultura/fumigacion aerea</code>
<p>The annoying part is it works EVERYWHERE apart from phpmyadmin ... am I missing anything? I've been coding for a fair time now, and I've only just taken the time to really look into the best practices for utf8/unicode... makes a LOT more sense now - but for some reason this just doesn't seem to wanna play ball :/</p>
<p>TIA</p>
Andy