How Can I Change Database and Database Tables To UTF8 Encoding?

A1WEBSITEPRO Questions › How Can I Change Database and Database Tables To UTF8 Encoding?
0 Vote Up Vote Down
Maximus Mccullough Staff asked 6 years ago

Is there a code I can use to change the database to UTF8 encoding?

How Can I Change Database and Database Tables To UTF8 Encoding? was last modified: July 10th, 2019 by Maximus Mccullough
Question Tags:
1 Answers
0 Vote Up Vote Down
Maximus Mccullough Staff answered 6 years ago

Yes enter this in your sql in phpmyadmin.

ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Answer for How Can I Change Database and Database Tables To UTF8 Encoding? was last modified: March 19th, 2023 by Maximus Mccullough