MySQL upgrade 4.0.27 to 4.1 or 5.0 to avoid charset issues?

E

expthep

Registered
Dec 14, 2006
1
0
151
A client who is using MySQL v. 4.0.27 asked me to upgrade it and pay particular attention to charsets.

Charset in all tables is latin1 and i was wondering if the upgrade would cause any problems with special characters (his website is in italian).

Will the upgrade through WHM create the right charsets/collations or will it try to convert everything to utf-8?

Should i first upgrade to 4.1 or is it safe to move to 5.0/ 5.1 ?

Thanks
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
G /usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 855 Databases 1
L upgrade from mysql 5.7 to 8.0 failed because of an old database with utf8mb3 characters Databases 5
R SOLVED MySQL 5.7 to MySQL 8.0 Upgrade Databases 7
T Upgrading from MySQL to Maria. No MariaDB upgrade option in WHM Databases 29
V SOLVED [UPS-421] MySQL 5.7.36 -> 5.7.37 upgrade failed due to GPG keys, causing upcp/rpmup failure warning email Databases 21
Similar threads
/usr/local/cpanel/Whostmgr/Mysql/Upgrade.pm line 855
upgrade from mysql 5.7 to 8.0 failed because of an old database with utf8mb3 characters
SOLVED MySQL 5.7 to MySQL 8.0 Upgrade
Upgrading from MySQL to Maria. No MariaDB upgrade option in WHM
SOLVED [UPS-421] MySQL 5.7.36 -> 5.7.37 upgrade failed due to GPG keys, causing upcp/rpmup failure warning email
Top Bottom