L
L
LeoPugachev2019-02-26 14:36:43
MySQL
LeoPugachev, 2019-02-26 14:36:43

Why doesn't MySQL database encoding change?

The customer had a problem that the Russian letters entered into the MySQL table were displayed as incomprehensible characters. I changed the table encoding to utf8mb4-unicode-ci, the problem was not solved. Then decided to change the encoding of the entire database in the phpMyAdmin home page, but the encoding just doesn't change! Why doesn't the encoding of the entire database change? And how else can you solve the problem with the display of Russian characters?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
R
Rsa97, 2019-02-26
@Rsa97

In addition to base encoding, there is also table encoding and individual column encoding.

A
Almot77, 2019-02-26
@Almot77

Look at the connection encoding.
https://dev.mysql.com/doc/refman/5.5/en/charset-co...
In phpmyadmin on the main page: MySQL Connection Charset Mapping

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question