phpmyadmin is not export some characters correctly
á becomes á
someone
11:11 pm on Dec 20, 2005 (gmt 0)
I am exporting my data from mysql into a csv file using phpmyadmin. When I open that csv file with MS Excel, some latin characters are not showing correctly. What do I have to do to export those characters correctly? Thanks.
coopster
9:43 pm on Dec 21, 2005 (gmt 0)
Are you sure the export isn't working correctly and it isn't MS Excel that isn't opening and displaying the data correctly?
ergophobe
7:05 pm on Dec 25, 2005 (gmt 0)
Those characters should not be a problem, since they are the same code points in ISO-8859-1, Windows-1252 and UTF-8. It's curious that, if exported properly, that Excel would have a problem.
Look at your tables. What character set are the tables using (if you do a mysqldump you should get this information for the "collation"). If it's not latin-1 that *could* be a problem.
