Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7375

FEDERATED + DISCOVERY can make UTF8 columns to be corrupted

    XMLWordPrintable

Details

    Description

      Having done on the remote server:

      create table t1 (line char(32) character set UTF8 not null) engine=myisam;
      insert into t1 values('Et si on était déjà à noël ?');
      select * from t1;

      returns:

      line
      Et si on était déjà à noël ?

      On the local server, a FEDERATED table to access it can be created as:

      create table t1 engine=FEDERATED
      connection='mysql://root:tinono@localhost:3307/test/t1';
      select * from t1;

      returns:

      line
      Et si on

      and issues on warning saying:

      Level Code Message
      Warning 1366 Incorrect string value: '\xE9tait ...' for column 'line' at row 1

      Note: This can be corrected by specifying the default charset of the local FEDERATED table as DEFAULT CHARSET=UTF8 or by explicitely defining the local table column not specifying its character set. But this is not clearly documented.

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bertrandop Olivier Bertrand
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.