Whoops - sorry wrong list Apologies
Adam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adam Lipscombe Sent: 31 March 2006 17:29 To: 'Sergei Organov'; [email protected] 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 [email protected] http://lists.nongnu.org/mailman/listinfo/info-cvs _______________________________________________ info-cvs mailing list [email protected] http://lists.nongnu.org/mailman/listinfo/info-cvs
