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 con
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
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.
My goal is to extract data from one of the data bases and be able to get then to the
other database betwe
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.
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
con