[MySQL] Change Collation in Database

You'll simply need to run an ALTER on each of the tables as follows:

Mã: Chọn tất cả

ALTER TABLE <table name> COLLATE utf8_general_ci;

If you also need to update the existing character encoding (unlikely by the sounds of things), you can use:

Mã: Chọn tất cả

ALTER TABLE <table name> CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;