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

Maximus Mccullough Staff asked 2 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

Tip: Click on images to make them larger. If you find anything wrong on this page or need further assistance please comment below or contact me. 🙂

Please like, share and subscribe.

Advanced Programming Made Easy

I hope you enjoyed the article. If I was able to help you please consider a tip for the content.

One Time Tip

more tips

Reoccuring Tips

Tips

Cool People Share:
1 Answers
Maximus Mccullough Staff answered 2 years ago

Yes enter this in your sql in phpmyadmin.

ALTER DATABASE databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Tip: Click on images to make them larger. If you find anything wrong on this page or need further assistance please comment below or contact me. 🙂
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: July 10th, 2019 by Maximus Mccullough

Subscribe To My YouTube Channel:

Please like, share and subscribe.

Advanced Programming Made Easy

I hope you enjoyed the article. If I was able to help you please consider a tip for the content.

One Time Tip

more tips

Reoccuring Tips

Tips

Cool People Share: