Title: Need Utf-8 in SQL backup
Last modified: September 1, 2016

---

# Need Utf-8 in SQL backup

 *  Resolved [devadas](https://wordpress.org/support/users/devadas/)
 * (@devadas)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/)
 * Hi!
    I install Updrafplus 1.12.15 to the site with non-latin content. All backup
   is ok except one point – in the my DB backup I see: – wrong characters instead
   of Cyrillic (Рецепты instead of Рецепты). So my UTF-8 convert to Win… –
   and backup file in ANSI format (not UTF-8 as usually).
 * I had read 10 pages of your Support pages (and I can’t more) but can’t find same
   problem and solution. Please help me.
 * [https://wordpress.org/plugins/updraftplus/](https://wordpress.org/plugins/updraftplus/)

Viewing 10 replies - 1 through 10 (of 10 total)

 *  Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568385)
 * What tool are you viewing the database backup in? It sounds likely that you need
   to reconfigure it. Note that text files don’t necessarily have an intrinsic encoding;
   rather, they are interpreted according to the preferences of the program that
   opens them.
 * David
 *  Thread Starter [devadas](https://wordpress.org/support/users/devadas/)
 * (@devadas)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568396)
 * Thank you for spending time.
 * I always use Notepad++ many years. In the bottom right I can see encoding.
 * I compare 2 files with db-backup – one from Updraftplus and one from protective
   plugin. And it is not my first backup, but the first experience with the version
   1.12.15 and WP 4.5.3. Earlier I used version 1.11.12 and WordPress was little
   older…
 * – Upfraftplus makes file in ANSI and russian words looks like Рецепты (
   it because of excess operation of coding from UTF-8 to Win)
    – Defense plugin
   makes UTF-8 file with proper words like Рецепт
 *  Thread Starter [devadas](https://wordpress.org/support/users/devadas/)
 * (@devadas)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568401)
 * I made tests with few versions of Updraftplus and few hostings. And can say that
   it depends on settings of the server, not a plug-in – earlier I used a hosting
   in Russia (problems with the coding weren’t), and now hosting in Germany (there
   are problems with the UTF-8 with any Updraftplus version – I have tried 1.11.12,
   1.11.15, 1.11.20 and so on).
 * But may be you can teach Updraftplus to understand the codepage of content correctly(
   Cyrillic etc.) irrespective of a hosting? I think that it is possible.
 *  Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568420)
 * Hi,
 * Text files don’t have an intrinsic encoding; the byte stream is interpreted by
   the interpreter according to its preferences. Does restoring the database backup
   in UpdraftPlus on the same site work?
 * David
 *  Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568421)
 * The database backup is just written out using PHP’s “fwrite” function – [https://secure.php.net/fwrite](https://secure.php.net/fwrite).
   If there’s something wrong, it’s likely to be the database. What’s your DB_CHARSET
   and DB_COLLATE settings in wp-config.php?
 * David
 *  Thread Starter [devadas](https://wordpress.org/support/users/devadas/)
 * (@devadas)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568433)
 * > What’s your DB_CHARSET and DB_COLLATE settings in wp-config.php?
    define(‘DB_CHARSET’,‘
   utf8mb4’); define(‘DB_COLLATE’, ”);
 * In PhpMyAdmin I can see, that all tables realy have utf8mb4 charset.
 * > Does restoring the database backup in UpdraftPlus on the same site work?
    I
   don’t try it, sorry… And even don’t want to try, because my experience prompts
   to me that if I see unclear badges instead of normal letters, then I will see
   same on the website after restoration…
 * However, I can try in some day if it helps you.
 *  Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568448)
 * Hi,
 * Feel free to send through an example of a problematic database file; send to 
   [4vwsedv-cn4@forward.cat](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/4vwsedv-cn4@forward.cat?output_format=md)–
   address valid for 1 week.
 * David
 *  Thread Starter [devadas](https://wordpress.org/support/users/devadas/)
 * (@devadas)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568449)
 * Hi!
 * I made database backup and restore from it. That’s all right – all my content
   is good. So your plugin do it correctly despite unusual things in a text editor
   or unusual hosting.
 * Some combination of circumstances, and I have drawn the wrong conclusion… Please
   forgive me for disturbance…
 * But possible it help to your users with non-Latin content and will give them 
   confidence.
 * Thank you.
 *  Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/)
 * (@davidanderson)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568450)
 * Hi,
 * Great – glad it works!
 * Non-Latin content shows fine in the DB backups I’ve taken. (UD has had pretty
   extensive testing in this area, and not had any related changes for a couple 
   of years. Non-Latin characters are extremely common these days).
 * David
 *  Thread Starter [devadas](https://wordpress.org/support/users/devadas/)
 * (@devadas)
 * [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568452)
 * > UD has had pretty extensive testing in this area, and not had any related changes
   for a couple of years
 * Yes, same experience. Always fine.
    I this case, probably, settings of a hosting
   and the editor have played a joke with me….

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Need Utf-8 in SQL backup’ is closed to new replies.

 * ![](https://ps.w.org/updraftplus/assets/icon-256x256.jpg?rev=1686200)
 * [UpdraftPlus: WP Backup & Migration Plugin](https://wordpress.org/plugins/updraftplus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/updraftplus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/updraftplus/)
 * [Active Topics](https://wordpress.org/support/plugin/updraftplus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/updraftplus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/updraftplus/reviews/)

## Tags

 * [utf-8](https://wordpress.org/support/topic-tag/utf-8/)

 * 10 replies
 * 2 participants
 * Last reply from: [devadas](https://wordpress.org/support/users/devadas/)
 * Last activity: [10 years ago](https://wordpress.org/support/topic/need-utf-8-in-sql-backup/#post-7568452)
 * Status: resolved