This is the official MySQL UDF Repository bug tracker. Please use it with care.
- Before submitting a new bug report, please make sure the bug is not already reported.
- Include the given error code, trace and any other debugging information supplied.
- Please leave your e-mail address, so we can get back to you if it is unclear how to reproduce the bug.
Thank you!
FS#6 - Unable to process with utf8 string
Attached to Project:
lib_mysqludf_json
Opened by 'alsan.wong-gmail' - Wednesday, 01 October 2008, 01:09 GMT+2
Opened by 'alsan.wong-gmail' - Wednesday, 01 October 2008, 01:09 GMT+2
|
DetailsSELECT json_values('???');
returns: "????? Even wrost: CREATE TABLE tt( idx INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, aa VARCHAR(100) NOT NULL ) DEFAULT CHARSET=utf8; INSERT INTO tt(aa) VALUES('a'), ('b'), ('aa'), ('abc'), ('???'); SELECT json_values(aa) FROM tt WHERE idx = 5; returns: "??????€???€? |
This task depends upon
SELECT json_values('???'); /* chinese characters in unicode: E4 B8 AD 0D 0A E6 96 87 0D 0A E5 AD 97 */
returns:
"????? /* 22 C3 A4 C2 B8 C2 AD C3 A6 E2 80 93 E2 80 A1 C3 A5 C2 AD E2 80 3F */
Even wrost:
CREATE TABLE tt(
idx INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
aa VARCHAR(100) NOT NULL
) DEFAULT CHARSET=utf8;
INSERT INTO tt(aa) VALUES('a'), ('b'), ('aa'), ('abc'), ('???');
SELECT json_values(aa)
FROM tt
WHERE idx = 5;
returns:
"??????€???€? /* 22 C3 A4 C2 B8 C2 AD C3 A6 E2 80 93 E2 80 A1 C3 A5 C2 AD E2 80 3F */