How to Change the Default Character Set of a MySQL Table?

Changing a MySQL Table's Default Character Set

This question addresses the challenge of modifying the default character set of a MySQL table. A table named 'etape_prospection' has been created with the default character set set to 'latin1', and the goal is to convert it to 'utf8'.

Solution:

To accomplish this task, a simple ALTER TABLE statement can be used:

<code class="sql">ALTER TABLE table_name CONVERT TO CHARACTER SET new_character_set;</code>

In this case, the specific statement to update the 'etape_prospection' table would be:

<code class="sql">ALTER TABLE etape_prospection CONVERT TO CHARACTER SET utf8;</code>

This statement will modify the table's default character set and convert all columns of character type to 'utf8'. The changes will be applied immediately, ensuring that any newly inserted data will use the new character set.

The above is the detailed content of How to Change the Default Character Set of a MySQL Table?. For more information, please follow other related articles on the PHP Chinese website!