in reply to
OT? Character set issues with MySQL/CGI::Application
For a quick-n-dirty fix, try this:
# $text is the variable containing "Espaņol" from the database
$text = encode("iso-8859-1", decode("utf-8", $text));
# now print $text
I don't want to use a hack like that in production code. Hmmmm.
In case of doubt print it out on the console and use hexdump to check.
Results (244 votes),