SugarCRM 8.0.3 upgrade to 9 MySQL utf8mb4 change

Hi everyone,

I have a question about the Sugar utf8mb4 requirements starting with version 9. As we see during our test upgrades, the upgrade script will try to convert encoding to the utf8mb4 encoding.

We tried to prepare for this by creating a slave MySQL server which already has the utf8mb4 encoding. However, MySQL will automatically convert all TEXT fields to MEDIUMTEXT in order to accomodate the extra space requirement. My tests show, that the upgrade script will then try to convert them back to TEXT, have you experienced this?

Has anyone been able to confirm that having utf8mb4 encoding with TEXT fields will be enough to hold all information in your previous instances, without getting any of the information lost/trimmed?

I appreciate your insights and help!

Greg

0 Viktor Ranga over 5 years ago

Something that you can try is to comment out the parts of the upgrader which change the character set and collation, and instead make these changes manually. The application should be fine with it.
0 Harald Kuske over 5 years ago

Make sure that you use the original mySQL server. All tests with MariaDB failed in my environments.

Harald Kuske
Principal Solution Architect – Professional Services, EMEA
hkuske@sugarcrm.com
SugarCRM Deutschland GmbH
0 Rodrigo Manara over 5 years ago

What MYSQL version are you using? If you don't have it correct version it my not work.

Rodrigo Manara

Sr. Developer
0 Harald Kuske over 5 years ago in reply to Rodrigo Manara

mysql-5.7.28, downloaded the package from the mysql website and installed it myself.

Harald Kuske
Principal Solution Architect – Professional Services, EMEA
hkuske@sugarcrm.com
SugarCRM Deutschland GmbH