B
B
Boris Shpakovsky2018-02-05 18:00:57
MySQL
Boris Shpakovsky, 2018-02-05 18:00:57

What can affect the change of Russian character encoding in MySQL databases when importing CSV?

I'm picking this plugin for creating a link directory: https://codecanyon.net/item/simple-link-directory-...
Everything in it is fine. But when importing from CSV, all Russian words turn into short words like: ÐÑовеÑка
The decoder says that this is an ISO encoding.
I naturally encode CSV in UTF-8, this is also mentioned in the plugin documentation. I tried to encode in different office suites, but the result is the same. Does this mean that the plugin does not understand Cyrillic in some place and converts it to another encoding? Please help me figure it out.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Antonio Solo, 2018-02-05
@kotboris

what you have is UTF-8 data that is displayed as 1251. i.e. for example, you took a file in UTF-8 and read it as 8-bit. or you send UTF-8 data to MySQL but say at the same time that they are 8-bit.
make a dump to a file when loading and you will see everything

K
Kirito Kagurazaka, 2018-02-05
@shomin2112

Perhaps indeed one plugin file has a different encoding from the others, it is also possible that the encoding is currently used in WordPress (maybe one file is also written in ASCII), but this all seems unlikely to me. Try to do WP in English, and convert again.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question