1
SET @@character_set_server=latin5;
2
CREATE DATABASE mysqltest1 DEFAULT CHARACTER SET cp1251;
4
CREATE DATABASE mysqltest2;
5
SHOW CREATE DATABASE mysqltest1;
6
Database Create Database
7
mysqltest1 CREATE DATABASE `mysqltest1` /*!40100 DEFAULT CHARACTER SET cp1251 */
8
SHOW CREATE DATABASE mysqltest2;
9
Database Create Database
10
mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin5 */
11
CREATE TABLE mysqltest2.t1 (a char(10));
12
SHOW CREATE TABLE mysqltest2.t1;
14
t1 CREATE TABLE `t1` (
15
`a` char(10) DEFAULT NULL
16
) ENGINE=MyISAM DEFAULT CHARSET=latin5
17
DROP TABLE mysqltest2.t1;
18
ALTER DATABASE mysqltest2 DEFAULT CHARACTER SET latin7;
19
CREATE TABLE mysqltest2.t1 (a char(10));
20
SHOW CREATE TABLE mysqltest2.t1;
22
t1 CREATE TABLE `t1` (
23
`a` char(10) DEFAULT NULL
24
) ENGINE=MyISAM DEFAULT CHARSET=latin7
25
DROP DATABASE mysqltest2;
26
CREATE DATABASE mysqltest2 CHARACTER SET latin2;
27
CREATE TABLE mysqltest2.t1 (a char(10));
28
SHOW CREATE TABLE mysqltest2.t1;
30
t1 CREATE TABLE `t1` (
31
`a` char(10) DEFAULT NULL
32
) ENGINE=MyISAM DEFAULT CHARSET=latin2
33
DROP DATABASE mysqltest2;
35
CREATE TABLE t1 (a char(10));
38
t1 CREATE TABLE `t1` (
39
`a` char(10) DEFAULT NULL
40
) ENGINE=MyISAM DEFAULT CHARSET=cp1251
42
CREATE TABLE t1 (a char(10)) DEFAULT CHARACTER SET latin1;
45
t1 CREATE TABLE `t1` (
46
`a` char(10) DEFAULT NULL
47
) ENGINE=MyISAM DEFAULT CHARSET=latin1
49
CREATE TABLE t1 (a char(10))
50
DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
53
t1 CREATE TABLE `t1` (
54
`a` char(10) COLLATE latin1_german1_ci DEFAULT NULL
55
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german1_ci
57
create table t1 (a char) character set latin1 character set latin2;
58
ERROR HY000: Conflicting declarations: 'CHARACTER SET latin1' and 'CHARACTER SET latin2'
59
create table t1 (a char) character set latin1 collate latin2_bin;
60
ERROR 42000: COLLATION 'latin2_bin' is not valid for CHARACTER SET 'latin1'
61
create database d1 default character set latin1 character set latin2;
62
ERROR HY000: Conflicting declarations: 'CHARACTER SET latin1' and 'CHARACTER SET latin2'
63
create database d1 default character set latin1 collate latin2_bin;
64
ERROR 42000: COLLATION 'latin2_bin' is not valid for CHARACTER SET 'latin1'
65
DROP DATABASE mysqltest1;
66
CREATE DATABASE mysqltest2 DEFAULT CHARACTER SET latin7;
68
ALTER DATABASE DEFAULT CHARACTER SET latin2;
69
show create database mysqltest2;
70
Database Create Database
71
mysqltest2 CREATE DATABASE `mysqltest2` /*!40100 DEFAULT CHARACTER SET latin2 */
72
drop database mysqltest2;
73
ALTER DATABASE DEFAULT CHARACTER SET latin2;
74
ERROR 3D000: No database selected
75
ALTER DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa DEFAULT CHARACTER SET latin2;
76
ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
77
ALTER DATABASE `` DEFAULT CHARACTER SET latin2;
78
ERROR 42000: Incorrect database name ''