Phpmyadmin is a web application that is dedicated to database management. It allows you to administer the server, run various commands, and view the contents of tables and databases.
Instructions
Step 1
Change the encoding of the database after creating it. Most scripts use utf-8 encoding, but on hosting databases are often created using cp-1251 encoding or another. This can lead to incorrect display of the article texts. Instead of letters, question marks or other incomprehensible symbols may appear. Therefore, check the database encoding before installing the script.
Step 2
Go to the control panel, select phpMyAdmin, after entering it from the drop-down list on the left side of the screen, select the desired database in which you want to change the encoding.
Step 3
Go to the "Operations" tab after selecting the database, here you can perform various operations with the existing database. One of the available operations is changing the encoding.
Step 4
From the drop-down list, mark the encoding you need, keep in mind that most scripts support utf-8. Then click the "Go" button. These steps must be completed before installing cms.
Step 5
Use the script Sypex Dumper Lite 1.0.8. to solve problems with base encoding. Save the database with a dumper, make sure all Russian characters are saved in it.
Step 6
After that, restore the tables with the same script from the dump. To fix character display problems, add the line mysql_query ("/ *! 40101 SET NAMES Enter an encoding name, for example, cp1251 '* /") or die ("Error:". Mysql_error ()) before calling mysql.select.db. After that, the base scripts will work with all versions.
Step 7
After that, go to the Phpmyadmin control panel, change the default encoding for your database, so that the newly created tables have the desired encoding. To do this, select a base, go to "Operations" from the "Comparisons" list, select the desired value corresponding to your data.
