summaryrefslogtreecommitdiff
path: root/mysql-test/t/ctype_recoding.test
blob: 68526806166ef60988b093f158afbfdad7afb7f6 (plain)
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
SET CHARACTER SET koi8r;

--disable_warnings
DROP TABLE IF EXISTS ÔÁÂÌÉÃÁ;
--enable_warnings

CREATE TABLE ÔÁÂÌÉÃÁ 
(
  ÐÏÌÅ CHAR(32) CHARACTER SET koi8r NOT NULL
);

SHOW TABLES;
SHOW CREATE TABLE ÔÁÂÌÉÃÁ;
SHOW FIELDS FROM ÔÁÂÌÉÃÁ;

SET CHARACTER SET cp1251;
SHOW TABLES;
SHOW CREATE TABLE òàáëèöà;
SHOW FIELDS FROM òàáëèöà;


SET CHARACTER SET utf8;
SHOW TABLES;
SHOW CREATE TABLE таблица;
SHOW FIELDS FROM таблица;

SET CHARACTER SET koi8r;
DROP TABLE ÔÁÂÌÉÃÁ;
SET CHARACTER SET default;