Encoding Issue while using French in WordPress

Question

I just migrated some content from another CMS [SPIP] into WordPress and I am seeing weird characters like ' Unité dans la diversité ', this is supposed to come in french but its not . Please let me know what can be done to convert this content into Unicode.

Praveen

Answer 1

Try to change encoding rule to utf8 in your databse. This can easily be done with phpMyAdmin for example. If this does not solve your issue, add encoding attribue to your Html tag.

Hope this helps.

Answer 2

I ran the Following bash script for the conversion from non unicode to utf-8

#!/bin/bash -e

DB_HOST="localhost"
DB_USER="username"
DB_PASSWORD="paassword"
DB_NAME="dbname"


mysqldump -h "$DB_HOST" -u "$DB_USER" - p"$DB_PASSWORD" --opt --quote-names -- skip-set-charset --default-character-set=latin1 "$DB_NAME" > /tmp/temp.sql;

mysql -h "$DB_HOST" -u "$DB_USER" - p"$DB_PASSWORD" --default-character- set=utf8 "$DB_NAME" < /tmp/temp.sql;

This did the job. I opened the DB in sublime text and the french characters were rendered correctly.

More information on this at https://codex.wordpress.org/Converting_Database_Character_Sets