Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.3.12, 5.5.39, 10.0.13
-
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.