v.23.7Experimental Feature

Experimental MaterializedMySQL: Automatic Text Type Conversion to UTF8

(experimental MaterializedMySQL) Introduced automatic conversion of text types to utf8 for MaterializedMySQL. #52084 (Val Doroshchuk).
Introduced automatic conversion of text types to UTF-8 encoding in the experimental MaterializedMySQL engine.

Why it matters

This feature addresses the issue of inconsistent text encoding when replicating data from MySQL to ClickHouse using MaterializedMySQL. By automatically converting text types to UTF-8, it ensures consistent character encoding, preventing data corruption and simplifying data handling for users.

How to use it

The automatic UTF-8 conversion is enabled by default in the experimental MaterializedMySQL engine. Users replicating MySQL tables with text columns using this engine will benefit from seamless UTF-8 conversion without additional configuration.