mysqldump - charset problem

Author Message

Artturi Markko

Sunday 28 May 2006 8:51:40 am

Hello,

I was running Ez 3.7.5 and made a backup via phpmyadmin before upgrading to ez 3.8.0.
My setup is apache 1.33, windows 2003, and mysql 4.1.12-nt

The only defined charset I've found in the ini settings come from i18n.ini and is :

[CharacterSettings]
Charset=iso-8859-1
HTTPCharset=
MBStringExtension=enabled

The problem is that the backup contains strange characters instead of accents and when restored, all accents are replaced with things like this :

dépôt des thèsesdépôt des thèses

1) Is there a way to get my accents back ?
2) What have I done wrong / what should I do to create a good backup ?

Thanks in advance,

Artturi

Artturi Markko

Sunday 28 May 2006 12:46:33 pm

I've just tested to dump a database with this syntax :

mysqldump --default-character-set=latin1 database > file.sql

and file.sql's content respects all the accents.

It seems to be a phpmyadmin problem (reading mysql's documentation :

--default-character-set=charset_name

Use charset_name as the default character set. See Section 5.11.1, “The Character Set Used for Data and Sorting”. If not specified, mysqldump uses utf8. 

Artturi

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.