| 1 |
DROP TABLE IF EXISTS t1; |
| 2 |
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gbk, FULLTEXT(a)) ENGINE = InnoDB; |
| 3 |
SET NAMES utf8mb4; |
| 4 |
DELETE FROM t1 LIMIT 1; |
| 5 |
SET NAMES latin1; |
| 6 |
DROP TABLE t1; |
| 7 |
CREATE TABLE t1(a VARCHAR(2) CHARACTER SET big5 COLLATE big5_chinese_ci, |
| 8 |
FULLTEXT(a)) ENGINE=<default_engine>; |
| 9 |
DROP TABLE t1; |
| 10 |
SET NAMES utf8mb4; |
| 11 |
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET gb18030, FULLTEXT(a)) ENGINE = InnoDB; |
| 12 |
INSERT INTO t1 VALUES(0xF043616161),(0xBEF361616197C22061616161); |
| 13 |
SELECT CONVERT(a USING utf8) FROM t1; |
| 14 |
CONVERT(a USING utf8) |
| 15 |
餋aaa |
| 16 |
倔aaa椔 aaaa |
| 17 |
Warnings: |
| 18 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 19 |
SELECT CONVERT(_gb18030 0x97C22061616161 USING utf8); |
| 20 |
CONVERT(_gb18030 0x97C22061616161 USING utf8) |
| 21 |
椔 aaaa |
| 22 |
Warnings: |
| 23 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 24 |
SELECT HEX(a), CONVERT(a USING utf8) FROM t1 WHERE MATCH(a) AGAINST(0x97C220616161 IN BOOLEAN MODE); |
| 25 |
HEX(a) CONVERT(a USING utf8) |
| 26 |
Warnings: |
| 27 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 28 |
SELECT HEX(a), CONVERT(a USING utf8) FROM t1 WHERE MATCH(a) AGAINST(0x97C22061616161 IN BOOLEAN MODE); |
| 29 |
HEX(a) CONVERT(a USING utf8) |
| 30 |
BEF361616197C22061616161 倔aaa椔 aaaa |
| 31 |
Warnings: |
| 32 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 33 |
SELECT HEX(a), CONVERT(a USING utf8) FROM t1 WHERE MATCH(a) AGAINST(0x97C2206161616161 IN BOOLEAN MODE); |
| 34 |
HEX(a) CONVERT(a USING utf8) |
| 35 |
Warnings: |
| 36 |
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous. |
| 37 |
SET NAMES latin1; |
| 38 |
DROP TABLE t1; |
| 39 |
CREATE TABLE t1 (a TEXT, FULLTEXT(a)) ENGINE=InnoDB DEFAULT CHARSET=gb18030 COLLATE=gb18030_bin; |
| 40 |
CREATE TABLE t2 (a TEXT, FULLTEXT(a)) ENGINE=InnoDB DEFAULT CHARSET=gb18030 COLLATE=gb18030_chinese_ci; |
| 41 |
CREATE TABLE t3 (a TEXT, FULLTEXT(a)) ENGINE=InnoDB DEFAULT CHARSET=gb18030 COLLATE=gb18030_unicode_520_ci; |
| 42 |
SELECT * FROM t1 WHERE MATCH(a) AGAINST(0xff00ff); |
| 43 |
a |
| 44 |
SELECT * FROM t1 WHERE MATCH(a) AGAINST(0xfe00feff8320218400010203); |
| 45 |
a |
| 46 |
SELECT * FROM t2 WHERE MATCH(a) AGAINST(0xff00ff); |
| 47 |
a |
| 48 |
SELECT * FROM t2 WHERE MATCH(a) AGAINST(0xfe00feff8320218400010203); |
| 49 |
a |
| 50 |
SELECT * FROM t3 WHERE MATCH(a) AGAINST(0xff00ff); |
| 51 |
a |
| 52 |
SELECT * FROM t3 WHERE MATCH(a) AGAINST(0xfe00feff8320218400010203); |
| 53 |
a |
| 54 |
DROP TABLE t1, t2, t3; |
| 55 |
SET NAMES utf8mb4 COLLATE utf8mb4_0900_ai_ci; |
| 56 |
CREATE TABLE t1(a VARCHAR(255) CHARACTER SET utf8mb4, FULLTEXT(a)) ENGINE = InnoDB; |
| 57 |
INSERT INTO t1 VALUES(0xC4B4616161),(0xE1B48C616161E292A92061616161); |
| 58 |
SELECT HEX(a), a FROM t1; |
| 59 |
HEX(a) a |
| 60 |
C4B4616161 Ĵaaa |
| 61 |
E1B48C616161E292A92061616161 ᴌaaa⒩ aaaa |
| 62 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST(0xE292A920616161 IN BOOLEAN MODE); |
| 63 |
HEX(a) a |
| 64 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST(0xE292A92061616161 IN BOOLEAN MODE); |
| 65 |
HEX(a) a |
| 66 |
E1B48C616161E292A92061616161 ᴌaaa⒩ aaaa |
| 67 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST(0xE292A9206161616161 IN BOOLEAN MODE); |
| 68 |
HEX(a) a |
| 69 |
TRUNCATE TABLE t1; |
| 70 |
INSERT INTO t1 VALUES("abcd"); |
| 71 |
INSERT INTO t1 VALUES("áƀcd"); |
| 72 |
INSERT INTO t1 VALUES("áƀde"); |
| 73 |
INSERT INTO t1 VALUES("áƀテストde"); |
| 74 |
SELECT HEX(a), a FROM t1; |
| 75 |
HEX(a) a |
| 76 |
61626364 abcd |
| 77 |
C3A1C6806364 áƀcd |
| 78 |
C3A1C6806465 áƀde |
| 79 |
C3A1C680E38386E382B9E383886465 áƀテストde |
| 80 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST("ab" IN BOOLEAN MODE); |
| 81 |
HEX(a) a |
| 82 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST("abcd" IN BOOLEAN MODE); |
| 83 |
HEX(a) a |
| 84 |
61626364 abcd |
| 85 |
SELECT HEX(a), a FROM t1 WHERE MATCH(a) AGAINST("áƀ*" IN BOOLEAN MODE); |
| 86 |
HEX(a) a |
| 87 |
C3A1C6806364 áƀcd |
| 88 |
C3A1C6806465 áƀde |
| 89 |
C3A1C680E38386E382B9E383886465 áƀテストde |
| 90 |
SET NAMES latin1; |
| 91 |
DROP TABLE t1; |