Problems with importing the british pound ( £) and euro (€) sign

[Adam Lipscombe]

Folks,


I have a mysql 5.0 db with the following char sets:

mysql> show variables like '%char%';
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | latin1                   |
| character_set_connection | latin1                   |
| character_set_database   | latin1                   |
| character_set_results    | latin1                   |
| character_set_server     | latin1                   |
| character_set_system     | utf8                     |
| character_sets_dir       | C:\MySQL\share\charsets\ |
+--------------------------+--------------------------+


I have a column that stores currency symbols  - two of which are the British
pound (£) and euro (€) sign.

I can I export via mysqldump no with problem - the "£" sign appears in the
export file OK, although the euro is converted into an odd looking set of
chars

But when I import using the command line client like this: "mysql -u <user>
-p<pwd> <dbname> < datadump.sql", the £ sign and euro sign get changed into
"£" and "€" respectively.

I have tried forcing the encoding by using "mysql
--default-character-set=latin1 -u <user> -p<pwd> <dbname> < datadump.sql"
but this produces the same results.


Any ideas?


TIA - Adam