And you are completely wrigth. There is no MySql problem. I solved the problem but I did not gave you all the necessary information. In the middle of all the problem there is also a php application, apache and the OS so I was confused. The problem was with php. In php.ini there is the following configuration: " ; As of 4.0b4, PHP always outputs a character encoding by default in ; the Content-type: header. To disable sending of the charset, simply ; set it to be empty. ; ; PHP's built-in default is text/html default_mimetype = "text/html" default_charset = "UTF-8" " I am testing in Linux and for testing purposes I have two scripts one for the database in Linux and another that have the windows data. I have only tested in Linux because wrigth now I cannot access the windows machine. With the above settings the "Linux" database will work fine. If I change the default_charset to "iso-8859-1" the "linux" database will show "strange" chars but if I load the "windows" database with iso-8859-1 as default charset then it will show all characters OK.
So what I will do is to put default_charset = "UTF-8" in the windows machine (I have no access to the hosting of course!) and it will work fine when exporting to Linux. I will test tomorrow. If there is some problem I will mail, if all goes well as I suspect no mail. Since these migth look confusing these is the solution I found. Put in php.ini the same default charset as your hosting if you want to be able to emulate the application and export your data without any trouble. I apologize for taking some of your time and hope these will be helpfull to someone in the future. Best regards. Carlos Díaz. --- Stefan Hinz <[EMAIL PROTECTED]> escribió: > Carlos, > > > Character set > > In windows 2000 latin1 > > In Linux hosting latin1 > > > Character sets > > In windows 2000 > > latin1 big5 czech euc_kr gb2312 gbk sjis tis620 > ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 > cp1251 danish hebrew win1251 estonia hungarian > koi8_ukr win1251ukr greek win1250 croat cp1257 > > latin5 > > > In Linux > > latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 > usa7 cp1251 danish hebrew win1251 estonia hungarian > koi8_ukr win1251ukr greek win1250 croat cp1257 > latin5 > > > phpMyAdmin version > > Windows 2.5.0 > > Linux 2.4.0 > > > MySql versions > > Windows MySQL 3.23.52-nt > > Linux MySQL 3.23.56-log > > I'm giving up, sorry. I cannot see anything in the > above that would > cause problems with Spanish characters when > exchanging the data > between those two servers. > > Does anyone else on this list see more than I do? > > > Stefan Hinz <[EMAIL PROTECTED]> wrote: > > Carlos, > > >> The character sets in both mysql severs in linux > and windows are the same. > >> When I query a table which has the same data in > spanish with accents I can see the characters > written are different. > > > 1) So what are the values of the character_set and > character_sets > > variables, anyway? > > > 2) Which MySQL server versions do you use, for the > local and the ISP > > server as well? > > > 3) Which version of phpMyAdmin do you use? Do they > differ on those two > > machines? > > >> My goal is to extract data from one of the data > bases and be able to get then to the other database > between linux ands windows without any problem. > >> Apache is used as web server in both Linux and > windows. > >> Regards. > >> Carlos Díaz > > > >> Stefan Hinz > > wrote: > >> 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 > >> iConnect GmbH > >> Heesestr. 6, 12169 Berlin (Germany) > >> Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > > >> [filter fodder: sql, mysql, query] > > > > >> --------------------------------- > >> Do You Yahoo!? > >> Todo lo que quieres saber de Estados Unidos, > América Latina y el resto del Mundo. > >> Visíta Yahoo! Noticias. > > > > Regards, > > -- > > Stefan Hinz > > iConnect GmbH > > Heesestr. 6, 12169 Berlin (Germany) > > Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 > > > [filter fodder: sql, mysql, query] > > > > > --------------------------------- > > Do You Yahoo!? > > Todo lo que quieres saber de Estados Unidos, > América Latina y el resto del Mundo. > > Visíta Yahoo! Noticias. > > > 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] > _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
