We are outputting a CSV file from a .Net (C#) application and it is writing
the euro currency sign (€), we are using the default encoding for the
StreamWriter class which is UTF-8 (65001).
When the file is viewed in notepad, it displays the character correctly but
in MS Excel 2003 (XP SP2) the character is translated to '€'.. We can
resolve the issue by specifiying the windows 1252 codpage when generating the
file, but we are wondering if this is the correct approach or it there a more
suitable solution?
Also what is the codepage used for MS Excel 2003? - is this dependant on the
OS Locale at all.
Cheers
Ollie Riches
|
Similar Threads
