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
