Character encoding of microns

[joec_]

Hi

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.

Joe