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 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.