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

Character set is ignored in Dynamic Column for saved string

Details

    • 10.0.23

    Description

      select hex(COLUMN_CREATE(1, "afaf" AS char character set utf8));
      hex(COLUMN_CREATE(1, "afaf" AS char character set utf8))
      0001000100030861666166

      08 above is character set number which is latin1, and 2D is UTF-8

      Attachments

        Activity

          select hex(COLUMN_CREATE(1, "ЫЫЫЫ" AS char character set utf8));
          hex(COLUMN_CREATE(1, "ЫЫЫЫ" AS char character set utf8))
          00010001000308D0ABD0ABD0ABD0AB

          i.e. the same

          sanja Oleksandr Byelkin added a comment - select hex(COLUMN_CREATE(1, "ЫЫЫЫ" AS char character set utf8)); hex(COLUMN_CREATE(1, "ЫЫЫЫ" AS char character set utf8)) 00010001000308D0ABD0ABD0ABD0AB i.e. the same

          sanja, please make sure that the KB has the option character set clause in syntax for dynamic column functions whereever it is applicable https://mariadb.com/kb/en/mariadb/dynamic-columns/ . If it's applicable everywhere along with char types, you can mention it in the datatypes section.

          elenst Elena Stepanova added a comment - sanja , please make sure that the KB has the option character set clause in syntax for dynamic column functions whereever it is applicable https://mariadb.com/kb/en/mariadb/dynamic-columns/ . If it's applicable everywhere along with char types, you can mention it in the datatypes section.

          revision-id: c2f2d50e376dfeadcf4c37afe51dc4bb0c32bbc4 (mariadb-10.0.22-41-gc2f2d50)
          parent(s): 537c750e328cd080365e465acd4f0383bf0febf3
          committer: Oleksandr Byelkin
          timestamp: 2015-12-14 15:02:39 +0100
          message:

          MDEV-9147: Character set is ignored in Dynamic Column for saved string

          Fixed moving charset from definition to the value.

          sanja Oleksandr Byelkin added a comment - revision-id: c2f2d50e376dfeadcf4c37afe51dc4bb0c32bbc4 (mariadb-10.0.22-41-gc2f2d50) parent(s): 537c750e328cd080365e465acd4f0383bf0febf3 committer: Oleksandr Byelkin timestamp: 2015-12-14 15:02:39 +0100 message: MDEV-9147 : Character set is ignored in Dynamic Column for saved string Fixed moving charset from definition to the value. —

          Ok to push with an additional test:

          SET NAMES utf8;
          SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET latin1), 1 AS CHAR CHARACTER SET utf8) AS a;
          SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET utf8), 1 AS CHAR CHARACTER SET utf8) AS a; 

          bar Alexander Barkov added a comment - Ok to push with an additional test: SET NAMES utf8; SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET latin1), 1 AS CHAR CHARACTER SET utf8) AS a; SELECT COLUMN_GET(COLUMN_CREATE(1, 0xC2A2 AS CHAR CHARACTER SET utf8), 1 AS CHAR CHARACTER SET utf8) AS a;

          People

            sanja Oleksandr Byelkin
            IllyaByelkin Illya Byelkin
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.