[nycphp-talk] fgetcsv and German characters
John Campbell
jcampbell1 at gmail.com
Tue Aug 14 14:03:48 EDT 2007
> Is there any way to tell what the encoding is from within Excel? (I
> didn't see anything in Excel and Google didn't have anything to
> offer.) I have the original Excel file.
You will never be able to figure out what is going on from within
Excel. Microsoft uses a lot of character set conversion/autodetection
magic across their products (heuristic determination of character
set). You need to open the csv with a text editor that let's you
change the display encoding. Once you know what the source encoding
is, and the destination encoding you want, you can use
mb_convert_encoding() in most cases.
I did some searching and \x9f and \x8a represent Ÿ and Š in MS-1252.
More information about the talk
mailing list