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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]