How to set the default character set for a table in MySQL?

There are two methods available to set the default character set for a MySQL table:

1. Specify character set when creating a table.

CREATE TABLE table_name (
    column1 datatype CHARACTER SET charset_name,
    column2 datatype CHARACTER SET charset_name,
    ...
) DEFAULT CHARACTER SET charset_name;

In the above statement, replace charset_name with the character set name you want to set. For example, you can use utf8 or utf8mb4 as the character set name.

1. Change the character set of an existing table:

ALTER TABLE table_name CONVERT TO CHARACTER SET charset_name;

Replace table_name with the name of the table for which you want to change the character set, and replace charset_name with the name of the character set you want to set.

Please note that if you only want to change the character set of a specific column in a table, you can use the following statement:

ALTER TABLE table_name MODIFY column_name datatype CHARACTER SET charset_name;