How to change collation for particular tables in cPanel?

0
712
How to change collation of particular tables collation using phpMyAdmin.
How to change collation of particular tables collation using phpMyAdmin.

MySQL enables you to store and process data in a wide variety of languages using various character sets. For some operations, such as comparing two strings, MySQL uses a set of rules to determine equality and sorting order. This set of rules is known as a collation.

Step 1: Login to cPanel.

Step 2: Go to Database Section and Select phpMyAdmin.

Step 3: View the phpMyAdmin Main Page and Go to Left pane. It has the list of available databases.

Step 4: It displays the List of Tables present in the database and select the table from the list of tables. Then Select Operation option at top of the page.

Step 5: Go to the Table options and select needed collation type to change collation. Then click Go button in Table option.

Step 6: Collation is altered and a successful message will be displayed.

Step 7: It will be updated on the database and displayed in the list of tables.

Step 1 Login to cPanel.
Step 2 Go to Database Section and Select phpMyAdmin.
Select phpMyAdmin.
Select phpMyAdmin
Step 3 View the phpMyAdmin Main Page and Go to left pane. It has the list of available Databases.
 phpMyAdmin Main Page and Go to Left pane. It has the list of Database available.
View the database
Step 4 It displays the list of tables present in the database and select the table from the list of tables. Then Select Operation option at top of the page.
select tables and clic opration option inside of more option
Select tables and click operation option
Step 5 Go to the Table options and select needed collation type to change collation and Click Go button in Table option.
ClickGo button in Table option.
Select needed collation type
Step 6 Collation is altered and a successful message will be displayed.

"<yoastmark

Step 7 It will be updated on the database and displayed in the list of tables.

"<yoastmark

 

LEAVE A REPLY

Please enter your comment!
Please enter your name here