Problem with "accents" with export and import database with PhpMyAdmin

Hello,

I realised an export of my database using PhpMyAdmin with the standard parameters for "jeu de caractère du fichier



As result, I lost all characters like é à ' ù , etc. Here are some exemples

• Distribués
• Test de l#39;environnement

What do I make for choice in the list to keep theses characters ? Here is what I have in the list




And when I import, does my choice be the same as for export ?

Thanks for help

Hello dnaton ,

Normally , you have to choose the format UTF-8 but ... If your database is not in format UTF-8 it's a little problem .

Since 4.4 , all database are in format utf-8 but if your database is older than 4.4 it's possible that it's not utf-8 .
Then , if in utf-8 you have problem , you can use the format windows1252 or iso8859-15.

For the export it's the same format than the import.

Hello Krowry,

Thanks for your answer.

I'm a little bit confused when I take a look on my Database, and what is store, displayed, and exported.

Here is some example, to try to understand what I say

What is displayed for the user :

The data store in Database (PhpMyAdmin) :

The structure for this field in the Database :

What is exported with a dump :

• I exported with /*!40101 SET NAMES latin1 */; or /*!40101 SET NAMES utf8 */;
• It is the same result

All my tables (without exception) in the Database are like this example :



But I've this information at the end of the list of all the tables :




So, I don't understand anymore

• Why it is good displayed but not good stored ? (and how it is possible ?)
• What are the good parameters (and where iput them) to export correctly what is displayed
• Is there a way to correct what is stored in the Database ?

I know, there is a lot of questions

Thanks

Hello,

I have exactly the same problem as dnaton.
I want to transfer my projeqtor database to another server.
Whether I use mysqldump or phpmyadmin, whether my target server is mysql or mariadb, projeqtor does not display accented characters but characters in utf8.
The target and source servers have been installed in the same way.

Thanks to reply.