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

Converting charset to BINARY should be instantaneous

Details

    Description

      This is a missing feature.

      Attachments

        Issue Links

          Activity

            create table t (a char(1) charset utf8mb4) engine=innodb;
            insert into t values ('ы');
            --error ER_DATA_TOO_LONG
            alter table t modify a char(1) charset binary, algorithm=copy;
            

            Here actual data is checked so this can't be instant.

            Same for varchar.

            kevg Eugene Kosov (Inactive) added a comment - create table t (a char(1) charset utf8mb4) engine=innodb; insert into t values ('ы'); --error ER_DATA_TOO_LONG alter table t modify a char(1) charset binary, algorithm=copy; Here actual data is checked so this can't be instant. Same for varchar .

            Probably INSTANT CHARSET ALTER would be possible for TEXT field but the scope of this ticket is pretty narrow. I'm closing it now because, IMO, it's not worth been implemented.

            kevg Eugene Kosov (Inactive) added a comment - Probably INSTANT CHARSET ALTER would be possible for TEXT field but the scope of this ticket is pretty narrow. I'm closing it now because, IMO, it's not worth been implemented.

            People

              kevg Eugene Kosov (Inactive)
              kevg Eugene Kosov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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