title: What encoding does MAC Excel use?
body: <p>I have a client that wants to export a .csv to the server where it will be parsed by PHP in order to generate a table with its data. I'm using iconv to convert to the appropriate encoding (UTF-8). Unfortunately I'm a on Windows, so I don't know what the source encoding is. </p>
  
  <p>What encoding would MAC Excel use to generate a .csv? I've tried so many different combinations, but none work on the french accents, which are - as far as I know - not arranged the same way in the MAC's charset as in UTF-8</p>
  
  <p>For example:</p>
  
  <p>The correct display should be:
  'Délégation'</p>
  
  <p>Most types of encoding (including using utf8_encode()) gives:
  'DÈlÈgation'</p>
  
  <p>macintosh to UTF-8 gives:
  'D»l»gation'</p>
  
  <p>If I open the .csv file - that was saved from MAC - on my PC, I see the french 'é' accents as 'È', so is there a possibility that saving the file onto my computer (or server) forces the file directly to UTF-8 so now the 'È' are the direct values of the characters, instead of an UTF-8 encoding misinterpretation?</p>
  
  <p><strong>Hex Dump</strong></p>
  
  <p>Using bin2hex(), the hex dump for the string:
  'DÈlÈgation 1' is:
  44c86cc8676174696f6e2031</p>
  
  <p>-- in fact, I'm assuming that it's DÈlÈgation and not Délégation because if I open the .csv file in notepad (on my PC), it shows it up as È and not é.</p>