[CONJ-797] Connector must use UTF8mb3 collation of Server Created: 2020-06-08  Updated: 2020-06-08  Resolved: 2020-06-08

Status: Closed
Project: MariaDB Connector/J
Component/s: configuration
Affects Version/s: 2.3.0, 2.2.4, 2.2.5, 2.2.6, 2.4.0, 2.4.1, 2.4.2, 2.4.3, 2.4.4, 2.5.0, 2.5.1, 2.5.2, 2.5.3, 2.5.4, 2.6.0
Fix Version/s: 2.6.1

Type: Bug Priority: Major
Reporter: Diego Dupin Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: None


 Description   

Driver relies on server default collation.

Since https://jira.mariadb.org/browse/CONJ-597 driver always use UTF8MB4 collation.
If server use utf8mb4 collation (collation_server), connector will use that collation (collation_connection).
If the server doesn't use utf8mb4 collation, the connector will force the use of utf8mb4_unicode_ci collation.

when a server is configured to use a utf8mb3 != than unicode, some query might result is Illegal mix of collations (utf8mb4_XXX_ci,COERCIBLE) and (utf8mb4_YYYY_ci,COERCIBLE) for operation '<>'). The server automatically handle utf8mb4 / utf8mb3 conversion, so before CONJ-597 change, so server configured in utf8 collation different than unicode may result in this issue.

The goal of this task is that upgrade of driver doesn't change compare to previous behaviour.
(when server send utf8mb3, client must use equivalent utf8mb4 collation)


Generated at Thu Feb 08 03:18:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.