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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
