Hi Experts,
Can someone help me to understand why Appian sets the CHARACTER SET as utf8mb3 for the varchar column even though we have CHARACTER SET utf8mb4,
Using Appian 22.4 cloud instance
Thanks,
Gaurav
Discussion posts and replies are publicly visible
Appian uses the utf8mb4 character set by default for its database connections.
One possibility is that the schema was generated using an earlier version of Appian that defaulted to utf8mb3 instead of utf8mb4.
Another possibility is that there may be some compatibility issues with certain MySQL versions that prevent the use of utf8mb4. In this case, Appian may fallback to using utf8mb3 instead.