Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-102

MySqlConnector does not support Chinese character encoded as utf8?

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Minor
    • 0.3.1, 0.4
    • 0.2.3
    • mysql-connector
    • None

    Description

      When monitoring a table with Chinese characters as fields value, the topic content shows ���

      I use example-myqsl docker images and here is the sql file for testing:

      set character_set_client=utf8;
      set character_set_connection=utf8;
      set character_set_database=utf8;
      set character_set_results=utf8;
      set character_set_server=utf8;
      create table inventory.test (
        id int(11) not null auto_increment,
        text varchar(255) default null,
        primary key (`id`)
      ) engine=InnoDB auto_increment=1006 default charset=utf8;
      insert into inventory.test values (default, "产品");
      

      watch-topic output:

      "after":{"id":1006,"text":"������"}
      

      Attachments

        Activity

          People

            rhauch Randall Hauch (Inactive)
            wangshao_jira barten barten (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: