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

[Adam Lipscombe]

Whoops - sorry wrong list

Apologies


Adam

-----Original Message-----
From: address@hidden
[mailto:address@hidden On Behalf
Of Adam Lipscombe
Sent: 31 March 2006 17:29
To: 'Sergei Organov'; address@hidden
Subject: Problems with importing the british pound (£) and euro (€) sign


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



_______________________________________________
info-cvs mailing list
address@hidden http://lists.nongnu.org/mailman/listinfo/info-cvs