Answer the question
In order to leave comments, you need to log in
How to change the display of question marks instead of Cyrillic?
Good day.
The site worked on utf-8 encoding and everything was fine, I decided to transfer the database to utf8mb4 now to utf8mb4, but the site displays question marks, although everything is displayed normally in the database itself.
Csm dle Problem
solved
Thanks to everyone who answered such a stupid question.
Only thanks to you, excluding everything that is not correct, by the method of futile attempts, I found one solution.
The problem was solved by "forcibly" changing the utf8_general_ci encoding for one of the columns and then changing everything back to utf8mb4_general_ci in PhpMyAdmin
More (Maybe something is superfluous here, I will list only the list of my actions)
PS I have an ISPmanager site control panel.
Updated PHP from 5.5 to 7
Updated MySQL
Executed a SQL query in PhpMyAdmin facing the database to the dle_post table
ALTER TABLE `db_name`.`table_name` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `db_name`.`table_name` CONVERT TO CHARACTER SET utf8 COLLATE utf8bit4_general_ci;
Answer the question
In order to leave comments, you need to log in
You can execute the following query in the application after connecting to the databaseset names utf8mb4
After connecting, there should be requests
SET character_set_connection = utf8mb4
SET character_set_client = utf8mb4
SET character_set_results = utf8mb4
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question