CHARACTER SET utf8mb3

Hi [mention:09cf3a8fdee34f5680a06848c77839c4:e9ed411860ed4f2ba0265705b8793d05],

Could you please share the evidence, the difference between database value and Appian value? with the specs. Thanks

Ró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.