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
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 wi
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
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) W
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
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 charac
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