COLLATION_MISMATCH error class

December 06, 2024

SQLSTATE: 42P21

Could not determine which collation to use for string functions and operators.

この記事の内容:

EXPLICIT

Error occurred due to the mismatch between explicit collations: [<explicitTypes>]. Decide on a single explicit collation and remove others.

IMPLICIT

Error occurred due to the mismatch between implicit collations: [<implicitTypes>]. Use COLLATE function to set the collation explicitly.