I had issues with accented characters(Spanish) in a csv, when open through excel, which was generated using php (not properly displayed). The encoding was utf-8. I have changed the encoding to UTF-8 with BOM. The issue found solved
But..... We need to upload this csv to a third party software and it does not accepts both the files(first one because of weird chars and second one because of unknown reasons). So now I found that when using the ansi encoding (windows-1252) the characters are displaying properly.
My question is, can the ansi encoding can represent all the Spanish characters?
Any other solution to this issue will also do good.
note: In notepad++ all the three encoding shows proper characters.