Question for Upgrade to V10 - Check MySQL8 Upgrade Compatibility
book
Article ID: 191912
calendar_today
Updated On:
Products
CA API GatewayAPI SECURITYCA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)CA API Gateway Enterprise Service Manager (Layer 7)STARTER PACK-7CA Microgateway
Questions: 1. Is this a problem that we should solve also before we do the upgrade? 2. Do you have a script which could convert from utf8mb3 to utf8mb4? 3. Do we need to change this or will it automatically be corrected when we migrate to the new MySQL8 Gateway Database?
Environment
Release : 9.4
Component : API GATEWAY
Cause
As per the log the warning are for following check-point:
Usage of utf8mb3 charset Warning: The following objects use the utf8mb3 character set. It is recommended to convert them to use utf8mb4 instead, for improved Unicode support. More information: https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html
bipro_db - schema's default character set: utf8 lost+found - schema's default character set: utf8 mysql - schema's default character set: utf8 ssg - schema's default character set: utf8 .
Resolution
Answering the questions 1. Is this a problem that we should solve also before we do the upgrade?
- not required, gateway works with utf8mb3 without any issue 2. Do you have a script which could convert from utf8mb3 to utf8mb4?
- As of now, gateway schema is not compatible with utf8mb4 due to table column size restrictions
3. Do we need to change this or will it automatically be corrected when we migrate to the new MySQL8 Gateway Database?