Utf8 Import problem

I use MySQL database with utf8 character set and utf8_czech_ci
collation.
It works well on Linux server but when I try to
export the data and import into the same database but running on XP
machine the utf8 is
gone.Instead of a proper coding there are some strange characters.

I used
mysqldump --default-character-set=utf8 mimi >/home/Result.sql
to export data to /home/Result.sql file on Linux machine.
Then I downloaded the file to my XP and here I used
mysql --default-character-set=utf8 mimi < Result.sql
to import data.
Is it correct?

Here are MySQL variable settings


LINUX MySQL settings
+--------------------------+----------------------------+
| Variable_name |
Value |
+--------------------------+----------------------------+
| character_set_client |
latin1 |
| character_set_connection |
latin1 |
| character_set_database |
utf8 |
| character_set_results |
latin1 |
| character_set_server |
latin1 |
| character_set_system |
utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |

| collation_connection | latin1_swedish_ci |
| collation_database | utf8_czech_ci |
| collation_server | latin1_swedish_ci |



XP Windows MySQL settings
+--------------------------+----------------------------------------------
------

| Variable_name | Value

+--------------------------+----------------------------------------------
------

| character_set_client | latin1

| character_set_connection | latin1

| character_set_database | latin1

| character_set_filesystem | binary

| character_set_results | latin1

| character_set_server | utf8

| character_set_system | utf8

| character_sets_dir | C:\Program Files\MySQL\MySQL Server
5.0\share\charsets\
+--------------------------+----------------------------------------------
------
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | utf8_czech_ci |
+----------------------+-------------------+


Any help would appreciated.
L.

Pythoni wrote:
> I use MySQL database with utf8 character set and utf8_czech_ci
> collation.
> It works well on Linux server but when I try to
> export the data and import into the same database but running on XP
> machine the utf8 is
> gone.Instead of a proper coding there are some strange characters.
>
> I used
> mysqldump --default-character-set=utf8 mimi >/home/Result.sql
> to export data to /home/Result.sql file on Linux machine.
> Then I downloaded the file to my XP and here I used
> mysql --default-character-set=utf8 mimi < Result.sql
> to import data.
> Is it correct?
>
> Here are MySQL variable settings
>
>
> LINUX MySQL settings
> +--------------------------+----------------------------+
> | Variable_name |
> Value |
> +--------------------------+----------------------------+
> | character_set_client |
> latin1 |
> | character_set_connection |
> latin1 |
> | character_set_database |
> utf8 |
> | character_set_results |
> latin1 |
> | character_set_server |
> latin1 |
> | character_set_system |
> utf8 |
> | character_sets_dir | /usr/share/mysql/charsets/ |
>
> | collation_connection | latin1_swedish_ci |
> | collation_database | utf8_czech_ci |
> | collation_server | latin1_swedish_ci |
>
>
>
> XP Windows MySQL settings
> +--------------------------+----------------------------------------------
> ------
>
> | Variable_name | Value
>
> +--------------------------+----------------------------------------------
> ------
>
> | character_set_client | latin1
>
> | character_set_connection | latin1
>
> | character_set_database | latin1
>
> | character_set_filesystem | binary
>
> | character_set_results | latin1
>
> | character_set_server | utf8
>
> | character_set_system | utf8
>
> | character_sets_dir | C:\Program Files\MySQL\MySQL Server
> 5.0\share\charsets\
> +--------------------------+----------------------------------------------
> ------
> | collation_connection | latin1_swedish_ci |
> | collation_database | latin1_swedish_ci |
> | collation_server | utf8_czech_ci |
> +----------------------+-------------------+
>
>
> Any help would appreciated.
> L.

I have no idea what's causing your problem, and would only assume that
Window does not support these characters (which is most unlikely). You
may wish to consider using utf8-general-ci instead?