[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Problems with importing the british pound ( £) and euro (€) sign
From: |
Adam Lipscombe |
Subject: |
Problems with importing the british pound ( £) and euro (€) sign |
Date: |
Fri, 31 Mar 2006 17:29:29 +0100 |
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
Re: changing the head to another branch, Larry Jones, 2006/03/31