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

CONVERT TO CHARACTER SET utf8 doesn't change DEFAULT CHARSET

    Details

    • Sprint:
      10.0.30

      Description

      in the case where no text columns

      > show create table seller_counters;
      | seller_counters | CREATE TABLE `seller_counters` (
        `seller_id` int(11) NOT NULL,
        `category_id` int(11) NOT NULL,
        `counter` int(11) NOT NULL DEFAULT '0',
        PRIMARY KEY (`seller_id`,`category_id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
       
      > select count(*) from seller_counters;
      | count(*) |
      |     1859 |
       
      > alter table seller_counters CONVERT TO CHARACTER SET utf8;
      Query OK, 0 rows affected (0.00 sec)
      Records: 0  Duplicates: 0  Warnings: 0
       
      > show create table seller_counters;
      | Table           | Create Table                                                                                                                                                                                                                  |
      | seller_counters | CREATE TABLE `seller_counters` (
        `seller_id` int(11) NOT NULL,
        `category_id` int(11) NOT NULL,
        `counter` int(11) NOT NULL DEFAULT '0',
        PRIMARY KEY (`seller_id`,`category_id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                holyfoot Alexey Botchkov
                Reporter:
                danblack Daniel Black
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: