1
SET CHARACTER SET koi8r;
2
DROP TABLE IF EXISTS �������, t1, t2;
3
SET CHARACTER SET koi8r;
4
CREATE TABLE t1 (a CHAR(10) CHARACTER SET cp1251) SELECT _koi8r'�����' AS a;
5
CREATE TABLE t2 (a CHAR(10) CHARACTER SET utf8);
9
`a` char(10) CHARACTER SET cp1251 DEFAULT NULL
10
) ENGINE=MyISAM DEFAULT CHARSET=latin1
14
SELECT HEX(a) FROM t1;
17
INSERT t2 SELECT * FROM t1;
18
SELECT HEX(a) FROM t2;
22
CREATE TABLE t1 (description text character set cp1250 NOT NULL);
23
INSERT INTO t1 (description) VALUES (_latin2'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasssssssssssaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbcccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddde');
24
SELECT description FROM t1;
26
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaasssssssssssaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbcccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccccddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddde
28
CREATE TABLE t1 (a TEXT CHARACTER SET cp1251) SELECT _koi8r'�����' AS a;
29
CREATE TABLE t2 (a TEXT CHARACTER SET utf8);
32
t1 CREATE TABLE `t1` (
33
`a` text CHARACTER SET cp1251
34
) ENGINE=MyISAM DEFAULT CHARSET=latin1
35
SELECT HEX(a) FROM t1;
38
INSERT t2 SELECT * FROM t1;
39
SELECT HEX(a) FROM t2;
43
CREATE TABLE `�������`
45
���� CHAR(32) CHARACTER SET koi8r NOT NULL COMMENT "����������� ����"
46
) COMMENT "����������� �������";
50
SHOW CREATE TABLE �������;
52
������� CREATE TABLE `�������` (
53
`����` char(32) CHARACTER SET koi8r NOT NULL COMMENT '����������� ����'
54
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='����������� �������'
55
SHOW FIELDS FROM �������;
56
Field Type Null Key Default Extra
58
SET CHARACTER SET cp1251;
62
SHOW CREATE TABLE �������;
64
������� CREATE TABLE `�������` (
65
`����` char(32) CHARACTER SET koi8r NOT NULL COMMENT '����������� ����'
66
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='����������� �������'
67
SHOW FIELDS FROM �������;
68
Field Type Null Key Default Extra
70
SET CHARACTER SET utf8;
74
SHOW CREATE TABLE таблица;
76
таблица CREATE TABLE `таблица` (
77
`поле` char(32) CHARACTER SET koi8r NOT NULL COMMENT 'комментарий поля'
78
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='комментарий таблицы'
79
SHOW FIELDS FROM таблица;
80
Field Type Null Key Default Extra
82
SET CHARACTER SET koi8r;
84
SET CHARACTER SET default;
86
CREATE TABLE t1 (t text) DEFAULT CHARSET UTF8;
87
INSERT INTO t1 (t) VALUES ('x');
88
SELECT 1 FROM t1 WHERE CONCAT(_latin1'x') = t;
92
SET CHARACTER SET koi8r;
99
SET CHARACTER SET cp1251;
104
SET CHARACTER SET koi8r;
110
SET character_set_connection=cp1251;
116
CREATE TABLE `тест` (`тест` int);
117
SHOW CREATE TABLE `тест`;
119
тест CREATE TABLE `тест` (
120
`тест` int(11) DEFAULT NULL
121
) ENGINE=MyISAM DEFAULT CHARSET=latin1
123
SHOW CREATE TABLE `тест`;
125
тест CREATE TABLE `тест` (
126
`тест` int(11) DEFAULT NULL
127
) ENGINE=MyISAM DEFAULT CHARSET=latin1
130
SET character_set_connection=utf8;
135
SET character_set_connection=binary;
140
CREATE TABLE t1 (`�` CHAR(128) DEFAULT '�', `�1` ENUM('�1','�2') DEFAULT '�2');
141
SHOW CREATE TABLE t1;
143
t1 CREATE TABLE `t1` (
144
`�` char(128) DEFAULT '�',
145
`�1` enum('�1','�2') DEFAULT '�2'
146
) ENGINE=MyISAM DEFAULT CHARSET=latin1
147
SHOW COLUMNS FROM t1;
148
Field Type Null Key Default Extra
150
�1 enum('�1','�2') YES �2
152
SHOW CREATE TABLE t1;
154
t1 CREATE TABLE `t1` (
155
`ä` char(128) DEFAULT 'ä',
156
`ä1` enum('ä1','ä2') DEFAULT 'ä2'
157
) ENGINE=MyISAM DEFAULT CHARSET=latin1
158
SHOW COLUMNS FROM t1;
159
Field Type Null Key Default Extra
161
ä1 enum('ä1','ä2') YES ä2
164
CREATE TABLE `good�����` (a int);
165
ERROR HY000: Invalid utf8 character string: '�����'
167
CREATE TABLE `good�����` (a int);
168
ERROR HY000: Invalid utf8 character string: '�����` (a int)'
170
create table t1 (a char(10) character set koi8r, b text character set koi8r);
171
insert into t1 values ('test','test');
172
insert into t1 values ('����','����');
174
Warning 1366 Incorrect string value: '\xCA\xC3\xD5\xCB' for column 'a' at row 1
175
Warning 1366 Incorrect string value: '\xCA\xC3\xD5\xCB' for column 'b' at row 1
178
create table t1 (a char(10) character set cp1251);
179
insert into t1 values (_koi8r'����');
180
select * from t1 where a=_koi8r'����';
183
select * from t1 where a=concat(_koi8r'����');
186
select * from t1 where a=_latin1'����';
187
ERROR HY000: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='
191
create table t1 (a char(1) character set latin1);
192
insert into t1 values ('a');
193
select * from t1 where a='a';
198
create table t1 (a char(10) character set utf8 collate utf8_bin);
199
insert into t1 values (' xxx');
200
select * from t1 where a=lpad('xxx',10,' ');
205
create table t1 (c1 char(10) character set cp1251);
206
insert into t1 values ('�');
207
select c1 from t1 where c1 between '�' and '�';
210
select ifnull(c1,'�'), ifnull(null,c1) from t1;
211
ifnull(c1,'�') ifnull(null,c1)
213
select if(1,c1,'�'), if(0,c1,'�') from t1;
214
if(1,c1,'�') if(0,c1,'�')
216
select coalesce('�',c1), coalesce(null,c1) from t1;
217
coalesce('�',c1) coalesce(null,c1)
219
select least(c1,'�'), greatest(c1,'�') from t1;
220
least(c1,'�') greatest(c1,'�')
222
select locate(c1,'�'), locate('�',c1) from t1;
223
locate(c1,'�') locate('�',c1)
225
select field(c1,'�'),field('�',c1) from t1;
226
field(c1,'�') field('�',c1)
228
select concat(c1,'�'), concat('�',c1) from t1;
229
concat(c1,'�') concat('�',c1)
231
select concat_ws(c1,'�','�'), concat_ws('�',c1,'�') from t1;
232
concat_ws(c1,'�','�') concat_ws('�',c1,'�')
234
select replace(c1,'�','�'), replace('�',c1,'�') from t1;
235
replace(c1,'�','�') replace('�',c1,'�')
237
select substring_index(c1,'����',2) from t1;
238
substring_index(c1,'����',2)
240
select elt(1,c1,'�'),elt(1,'�',c1) from t1;
241
elt(1,c1,'�') elt(1,'�',c1)
243
select make_set(3,c1,'�'), make_set(3,'�',c1) from t1;
244
make_set(3,c1,'�') make_set(3,'�',c1)
246
select insert(c1,1,2,'�'),insert('�',1,2,c1) from t1;
247
insert(c1,1,2,'�') insert('�',1,2,c1)
249
select trim(c1 from '�'),trim('�' from c1) from t1;
250
trim(c1 from '�') trim('�' from c1)
252
select lpad(c1,3,'�'), lpad('�',3,c1) from t1;
253
lpad(c1,3,'�') lpad('�',3,c1)
255
select rpad(c1,3,'�'), rpad('�',3,c1) from t1;
256
rpad(c1,3,'�') rpad('�',3,c1)
260
create table t1(a char character set cp1251 default _koi8r 0xFF);
261
show create table t1;
263
t1 CREATE TABLE `t1` (
264
`a` char(1) CHARACTER SET cp1251 DEFAULT '�'
265
) ENGINE=MyISAM DEFAULT CHARSET=latin1
267
create table t1(a char character set latin1 default _cp1251 0xFF);
268
ERROR 42000: Invalid default value for 'a'