D
D
Dmitry Petrik2014-07-09 20:01:08
MySQL
Dmitry Petrik, 2014-07-09 20:01:08

MySQL. How to convert latin to utf8?

In general, such a problem. Users entered the database of various Cyrillic words. And the encoding of the table was latin. In time it did not trace now all the information in the database in the form of question marks. Like this: "????? - ???????? ???".
How can I translate these question marks into Cyrillic?
I could not google something on my problem (just when the text became in the form of question marks).

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vit, 2014-07-09
@fornit1917

I made a dump, converted it to utf-8 and uploaded it back.

X
xSkyFoXx, 2014-07-10
@xSkyFoXx

Unfortunately, the built-in MySQL tools do not. Or through a backup or a script that makes elementary steps - select -> delete -> decode -> encode -> insert.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question