Apache Friends Support Forum

It seems like xampp mysql installed having DEFAULT CHARSET=latin1


Having done a search on the site, I found some answers where the my.cnf file has to be configured with something like:collation-server = latin1_swedish_ci <--or whatever charset I want
The problem is:
I have seen that for some people who had trouble with mambo, wordpress, the solution was to use the latin1 charset.
I get errors about the charset when I export a db with phpmyadmin and then try to import it using SQL into my ISPs database.
How do I know what charset to use?
Where in the my.cnf do I add the line?

thanks a lot!!

MySQL from XAMPP ist running with charset=Latin1. So there is no problem with mambo...

But:

I get errors about the charset when I export a db with phpmyadmin and then try to import it using SQL into my ISPs database.

phpMyAdmin exports only with UTF-8. And then you have trouble to import the file in your ISP database. You must use the tool "mysqlexport" together with the charset switch.

when I export a table using phpmyadmin, it has the following line:
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
so it looks like my installation of xampp is running with charset=Latin1
How can I tell phpmyadmin to not add the charset info?
thanks