Change utf8mb4 to utf8 by default?

Cheerag Nundlall

Well-known member
Registered
Joined
Oct 12, 2016
Messages
336
Points
18
on my hosting control panel, when I create a new database it always set as utf8mb4, i didn't see any options to change it to utf8, that made some errors when importing database on a new hosting. How can I change utf8mb4 to utf8 by default for every new databases?
 

Edward

Well-known member
Hosting Provider
Registered
Joined
Sep 1, 2018
Messages
109
Points
18
Create a database utf8 directly in the panel phpMyAdmin.
 

mariablassingame

New member
Registered
Joined
May 24, 2019
Messages
10
Points
3
If MySQL's docs do not help you with this beautiful basic data integrity concern, button to PostgreSQL, which has never had the truncated and also pointless half-way assistance for utf-8 that MySQL has passed off on individuals. You'll observe that a lot of points simply work as promoted, and are simply there when you reach for them.
 
Latest Threads
Replies
1
Views
25
Replies
0
Views
180
Replies
1
Views
39
Replies
2
Views
81
Recommended Threads
Replies
1
Views
2,478
Replies
3
Views
2,105
Replies
6
Views
3,443
Replies
1
Views
4,182

Latest postsNew threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top