A database** is a set of linked tables. And it is in them that all the information on your site is stored.
Changing encodings via phpmyadmin and text editor
Do export database via phpmyadmin to your local computer
Open the database in Notepadqq or Notepad2 text editor and change the script files, convert them to UTF-8/BOM encoding.
Import database back through phpmyadmin into the newly created database.
** Changing the encoding through a query to convert the database**
Go into phpmyadmin → on the left side click on your database → SQL tab and execute.
ALTER TABLE `db_name`.`table_name` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
This query converts the database to the specified encoding available for MySQL
In addition, it will need to convert the encodings of the tables themselves. It is possible to convert tables individually, but the inconvenience arises with a large number of tables. This can be done through a single query.
Query to convert the database tables:
SELECT CONCAT( 'ALTER TABLE `', t.`TABLE_SCHEMA` , '`.`', t.`TABLE_NAME` , '` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;' ) AS sqlcode FROM `information_schema`.`TABLES` t WHERE 1 AND t.`TABLE_SCHEMA` = 'DATABLES_NAME' ORDER BY 1 LIMIT 0 , 90
Instead of MY_DATABASE_Name you need to specify the name of your database
In the case of phpMyAdmin, all you have to do is copy this query and paste it into the SQL query form.
If you have any difficulties in setting up or have any additional questions, you can always contact our support team via [Ticket system] (https://fornex.com/my/tickets/).