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
Hi Gaurav,
utf8mb3 supports only characters in the Basic Multilingual Plane (BMP). utf8mb4 additionally supports supplementary characters that lie outside the BMP
For all character data types (CHAR, VARCHAR, and the TEXT types), the maximum number of characters that can be indexed is less for utf8mb4 columns than for utf8mb3 columns.
Thank you sir.