DEFAULT CHARSET=latin1 !!!!

Problems with the Windows version of XAMPP, questions, comments, and anything related.

DEFAULT CHARSET=latin1 !!!!

Postby apachefriend » 17. March 2005 20:46

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!!
apachefriend
 
Posts: 5
Joined: 06. January 2005 17:12

Postby Wiedmann » 17. March 2005 23:02

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Postby apachefriend » 18. March 2005 20:26

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 :roll:
How can I tell phpmyadmin to not add the charset info?
thanks
apachefriend
 
Posts: 5
Joined: 06. January 2005 17:12


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 54 guests