forked from mysql/mysql-server
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcharset.result
52 lines (52 loc) · 2.14 KB
/
charset.result
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
#
#Bug#21958734: INNODB: FAILING ASSERTION: *MBMAXLEN < 5 IN
# FILE HA_INNODB.CC LINE 1803
#
SHOW CHARACTER SET LIKE '%filename%';
Charset Description Default collation Maxlen
SHOW COLLATION LIKE '%filename%';
Collation Charset Id Default Compiled Sortlen
SELECT _filename'abcd';
ERROR 42S22: Unknown column '_filename' in 'field list'
SELECT CONVERT(_latin1'abcd' USING filename);
ERROR 42000: Unknown character set: 'filename'
SELECT CAST(_latin1'abcd' AS CHAR CHARACTER SET filename);
ERROR 42000: Unknown character set: 'filename'
SET NAMES 'filename';
ERROR 42000: Unknown character set: 'filename'
SET NAMES 'utf8';
SET CHARACTER_SET_CLIENT=17;
ERROR 42000: Unknown character set: '17'
SET CHARACTER_SET_CLIENT=33;
DROP DATABASE IF EXISTS db21958734;
CREATE DATABASE db21958734 CHARACTER SET filename;
ERROR 42000: Unknown character set: 'filename'
CREATE DATABASE db21958734 COLLATE filename;
ERROR HY000: Unknown collation: 'filename'
CREATE DATABASE db21958734 CHARACTER SET utf8;
ALTER DATABASE db21958734 CHARACTER SET filename;
ERROR 42000: Unknown character set: 'filename'
ALTER DATABASE db21958734 COLLATE filename;
ERROR HY000: Unknown collation: 'filename'
ALTER DATABASE db21958734 CHARACTER SET latin1;
USE db21958734;
CREATE TABLE t1(a VARCHAR(10)) CHARACTER SET filename;
ERROR 42000: Unknown character set: 'filename'
CREATE TABLE t1(a VARCHAR(10)) COLLATE filename;
ERROR HY000: Unknown collation: 'filename'
CREATE TABLE t1(a VARCHAR(10) CHARACTER SET filename);
ERROR 42000: Unknown character set: 'filename'
CREATE TABLE t1(a VARCHAR(10) COLLATE filename);
ERROR HY000: Unknown collation: 'filename'
CREATE TABLE t1(a VARCHAR(10) CHARACTER SET utf8) CHARACTER SET latin1;
ALTER TABLE t1 CHARACTER SET filename;
ERROR 42000: Unknown character set: 'filename'
ALTER TABLE t1 COLLATE filename;
ERROR HY000: Unknown collation: 'filename'
ALTER TABLE t1 CHARACTER SET gbk;
ALTER TABLE t1 MODIFY a VARCHAR(10) CHARACTER SET filename;
ERROR 42000: Unknown character set: 'filename'
ALTER TABLE t1 MODIFY a VARCHAR(10) COLLATE filename;
ERROR HY000: Unknown collation: 'filename'
ALTER TABLE t1 MODIFY a VARCHAR(10) CHARACTER SET cp932;
DROP DATABASE db21958734;