How do you set collation rules in MySQL?

1 year ago
William Carter
1 minute

In MySQL, you can use the ALTER TABLE statement to set or change the collation of a table.

The following is the syntax for the verification rules for the settings table.

ALTER TABLE table_name
COLLATE collation_name;

In this case, table_name refers to the name of the table where the collation rules will be set, and collation_name refers to the name of the collation rules to be used.

For example, set the collation rules of the table to utf8_general_ci:

ALTER TABLE my_table
COLLATE utf8_general_ci;

Note: The proofreading rules will only affect the comparison and sorting of strings, not storage.

bannerAds