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

GBK: bad results for SELECT "\{BF5C}\t'

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.3.12, 5.5.39, 10.0.13
    • 5.5(EOL)
    • None
    • None

    Description

      Multi-byte GBK characters with 0x5C do not work well in
      combination with surrounding backslash escapes.

      To repeat the bug, run a gnome-terminal session and set
      its character set to GBK:

      Terminal -> Character Coding -> Simplified Chinese (GBK)

      Run this command:

      LANG=zh_CN.gbk mysql --default-character-set=gbk test

      and execute this script:

      SET NAMES gbk;
      SELECT HEX('縗\t'),HEX('\縗\t');

      The output does not look correct:

      +-------------+--------------+
      | HEX('縗\t') | HEX('\縗\t') |
      +-------------+--------------+
      | BF5C09      | BF5C74       |
      +-------------+--------------+

      According to the manual section "String Literals":

      For all other escape sequences, backslash is ignored. That is, the escaped character is interpreted as if it was not escaped.

      That is '\縗' should be interpreted as just '縗 (0xBF5C),
      then '\t' should be interpreted as TAB (0x09).

      The expected result should be BF5C09 for both columns.

      Attachments

        Activity

          People

            bar Alexander Barkov
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.