Hi, Alexander, On Mar 08, Alexander Barkov wrote:
revision-id: b657bc75f90 (mariadb-11.0.1-262-gb657bc75f90) parent(s): 8e5f41b3453 author: Alexander Barkov committer: Alexander Barkov timestamp: 2023-11-15 10:58:03 +0400 message:
MDEV-25829 Change default collation to utf8mb4_1400_ai_ci
Step#2 - Adding a new collation derivation level for CAST and CONVERT.
Now character string cast functions: - CAST(string_expr AS CHAR) - CONVERT(expr USING charset_name)
have a new collation derivation level between:
- string literals - utf8 metadata functions, e.g. user() and database()
Before the change these cast functions had collation derivation equal to table columns, which caused more illegal mix of collation conflicts.
Note, binary string cast functions: - CAST(string_expr AS BINARY) - CONVERT(expr USING binary) did not change their collation derivation.
Why not? Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org