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?
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?
