Re^10: how to output file in Unicode

this "BjÃ¶rn" appear only if i open the csv output file using microsoft excel

using notepad or Editplus (editor) it looks good.

Comment on Re^10: how to output file in Unicode

Replies are listed 'Best First'.
Re^11: how to output file in Unicode by Anonymous Monk on Aug 28, 2012 at 07:11 UTC
What encoding does the "microsoft excel" program think the file is in?	[reply]
Re^11: how to output file in Unicode by anakin30 (Acolyte) on Aug 28, 2012 at 07:17 UTC
i changed it once, but it doesn't work out, i still seeing the character as "BjÃ¶rn". i don't know why? but how to ensure the output was delivered in UTF-8 encoded? is there any way i can prove? why the string still displayed as "BjÃ¶rn" even though i set the output to encoding(UTF-8), as below line `open (OUTPUT, ">:encoding(UTF-8)",$outputfile) or die "Cannot open filename for input: $!";`	[reply] [d/l]
Re^12: how to output file in Unicode by anakin30 (Acolyte) on Aug 28, 2012 at 08:49 UTC
when i open the generated csv output file in excel, and when i click "save as" i see the file recognized as a *.csv file. Any other i can use to check the file being open on which format or encoding??	[reply]
Re^13: how to output file in Unicode by Corion (Patriarch) on Aug 28, 2012 at 09:01 UTC
Use the "file -> open" dialog. There you can specify the encoding for text files in Excel.	[reply]
Re^14: how to output file in Unicode by anakin30 (Acolyte) on Aug 28, 2012 at 11:12 UTC
Re^15: how to output file in Unicode by Corion (Patriarch) on Aug 28, 2012 at 11:30 UTC