[daffy_dowden]

I'm backing up a database I'm working on that contains a lot of text in French, and i've noticed that within the sql backup files, all of the French characters have been replaced by strange symbols, such as copyright logos and the like.

How can I stop it from garbling this data?

I have the Collation set to latin1_general_cs in the character set for the table. Is there something else that I need to perform?

Thanks,
Daf

[ortho]

You see that when you restore, or in the backup it-self?

[ortho]

Maybe you can perform this command to make your backup:

mysqldump -Q --add-drop-table --default-character-set=utf8 --compatible=mysql40 --set-charset=utf8 DATABASENAME > BACKUP.SQL

where DATABASENAME is the name of your database and BACKUP.SQL is the name of the sql dump file.

Note that some parameters are optional like "--add-drop-table".

[daffy_dowden]

Hi Ortho,
Just before I try your code suggestion I just wanted to say that I see it in the sql backup, but when I re-import this code the affected characters are imported incorrectly too.

[daffy_dowden]

just tried the command, and I'm still getting the weird characters. When I ran the command it said that the --set-charset had an invalid value for utf8 though.

[thrash.zhai]

may be you should try this command:
mysqldump -uusername -ppassword --default-character-set=latin1 databasename > backup.sql

i think the parameter(--default-character-set) is the same as your database charset.