I have a string($str) that has some chinese, french and japanese text(in the same string) that are read from the Database. It is read correctly which I am able to verify by printing in the web page directly. But I am not able to write it in a excel file. Tried this:
@arr = split(',',$str);
$arrayref = \@arr;
Now, when I try to print it, using :
I get question marks in the place of special characters.
So I tried : $str = encode("utf8",$str);
. Still the same problem persists. Someone kindly guide me as how to do it.