Carlos, > We have a hosting provider with a Linux box and an MySql database. > We have a local Mysql database. > In both machines I use phpMyAdmin.
On the startpage (right frame) of phpMyAdmin you should see a link called "Show MySQL system variables". Look what the values of the variables character_set and character_sets are. > When I export from Windows to Linux then all the data in Linux is messed up with > respect to special characters, we work in spanish and all accents are lost and > converted to some extrange character. > When I export from Linux to Windows the same thing happens. > Of course these has to do with character sets. Most probably the two MySQL servers you are using have different character sets. > żAny suggestion? You can find more detailed information here: http://www.mysql.com/doc/en/Character_sets.html And here: http://www.mysql.com/doc/en/SHOW_VARIABLES.html Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
