0

I´m having trouble with the output to a csv file with the euro sign. i´ve tried using € which doesn´t work and the &euro which also doesn´t work. This only works in my table view but not when exported to csv.

Hopes someone could help me out.

UPDATE: I forgot to say that what shows instead of the eurosign is this symbol: Â

'€ '
Graham
  • 1,850
  • 4
  • 21
  • 41
  • Oh that's a typo. Im using it with the semicolon. € doesn't work either. But thanks for the help. Do you know another way? – Graham Apr 12 '14 at 19:56

2 Answers2

1

Old thread but I am answering it anyway for anyone finding this thread via a search engine.

What really worked for me is the following conversion:

echo iconv("UTF-8", "CP1252", $csv);

No encoding headers oder other conversions needed, just use the Symbol "€". This has been working since Office 2000 or earlier and still works with Office 2016/365.

Alexander Uhl
  • 184
  • 3
  • 7
0

I personally would run a utf8 encoding function on the file

Example

mb_convert_encoding($csv, 'UTF-16LE', 'UTF-8');
Kevin Lynch
  • 24,427
  • 3
  • 36
  • 37