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

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

                Dates

                Created:
                Updated: