Question: Change MySql collation from latin1 to ut8_general

nadav123

Well-Known Member
Mar 2, 2020
159
18
18
Orlando, FL
cPanel Access Level
Root Administrator
Hello, i see the default of cPanel for MySQL is Latin1:
https://support.cpanel.net/hc/en-us...haracter-set-for-MySQL-on-cPanel-WHM-servers-

all the tables inside,
already utf8 binary/general except 2, this 2 is in latin1.

but!
utf8 general read latin1,

and not need to actually convert the table, is only the connection of the MySQL
now,
I change inside my.cnf, the default-charter but is not affecting throw PHPMyAdmin and you still see the connection in latin1. ( attached screenshot )

I see a lot of people directly to the MySQL website.
but, it actually can be done easily throw PHPMyAdmin in a click button as you said here for cPanel:
https://support.cpanel.net/hc/en-us...or-character-set-for-your-database-in-cPanel-

of course this thing need to be done throw whm and not cpanel if you want change something like this. (this docs say only on cPanel and not WHM)

I try to stick cPanel defaults and recommendations.

My question is:
if we can change this latin1 (not per tables inside MySQL! i mean to MySQL main table)

and change it to utf8_general FROM latin1_swidin

Throw PHPmyadmin: ( i attached screenshot as well ):
WHM >> PHPMYADMIN >> DATABASES >> MYSQL >> OPERATIONS



Is very easy and much better than Latin1, of course, utf8 and utf8mdb can read the latin1 collation much faster.


but i don't know the cPanel software on the little details, like you guys, so is better to ask you first.

Recommendations? possible to do what i want, or has someone tried to do it before and got problems?
 

Attachments

cPanelAnthony

Administrator
Staff member
Oct 18, 2021
1,045
112
118
Houston, TX
cPanel Access Level
Root Administrator
Hello! While latin1 is the default character set, it shouldn't be a problem to change it. While you would want to confer with a database admin if you're unsure of which character set to use, there's nothing within cPanel that would stop working or have issues if you switch to utf8 for the character set. It sounds like you've already done your research and are well versed in character sets! The following article may help as well.

Change the collation or character set f or your cPanel database
 

nadav123

Well-Known Member
Mar 2, 2020
159
18
18
Orlando, FL
cPanel Access Level
Root Administrator
this is in cPanel, not WHM.
MySQL table does not appear on cPanel, only WHM... this table is not a regular table. is the connection between all the servers to MariaDB.

I Think to have a reason they didn't note that, but i checked it on the websites, and Plesk create the databases on UTF8MB4 ( which is very good )

BUT I STILL SUSPECT ON MYSQL TABLE COLLATION AND CHANGE THE GENERAL COLLATION TO UTF8 FROM LATIN

this thing must be done throw WHM and not cPanel, this is why i not sure 100% about this.


If you are sure about that i gonna change it to:
utf8_general_ci

must of the tables inside MYSQL is utf8_general_ci. (except 2 they latin)
if you can verify this change for me i will be sure 100% is matches all the panel demends.
 

Attachments