Need Utf-8 in SQL backup

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

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 Рецепт

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.

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

The database backup is just written out using PHP’s “fwrite” function – 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

> 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.

Hi,

Feel free to send through an example of a problematic database file; send to [email protected] – address valid for 1 week.

David

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.

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

> 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….