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 GauravSingh,Could you please share the evidence, the difference between database value and Appian value? with the specs. ThanksRómulo
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.
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.