joec_ has asked for the wisdom of the Perl Monks concerning the following question:


This kind of question may have been asked before, but here goes:

I have a clob that is returned from an Oracle database with encoding WE8ISO8859P1. Contained in the clob are various scientific symbols such as the micron sign

This seems to display ok when i look at the table in TOAD, but when i fetch the data and write it to a file, the micron gets replaced with a question mark.

I have tried the following, with no success, using the Encode module.

use Encode; open (OUTPUT, ">$filename"); $clob = $sth->fetch; $convertedstr = decode("iso-8859-1",$clob); print OUTPUT $convertedstr;
But this still prints ? for the micron symbols. Do i need a different encoding or some such?

Thanks in advance.


Eschew obfuscation, espouse eludication!