blob: 5afd2c041c84429fe40ecfa445772978a8e4a91c (
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
SET CHARACTER SET koi8r;
DROP TABLE IF EXISTS таблица, t1;
SET CHARACTER SET koi8r;
CREATE TABLE t1 (a CHAR(10) CHARACTER SET cp1251) SELECT _koi8r'проба' AS a;
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` char(10) character set cp1251 default NULL
) TYPE=MyISAM DEFAULT CHARSET=latin1
SELECT a FROM t1;
a
проба
SELECT HEX(a) FROM t1;
HEX(a)
EFF0EEE1E0
DROP TABLE t1;
CREATE TABLE `таблица`
(
поле CHAR(32) CHARACTER SET koi8r NOT NULL COMMENT "комментарий поля"
) COMMENT "комментарий таблицы";
SHOW TABLES;
Tables_in_test
таблица
SHOW CREATE TABLE таблица;
Table Create Table
таблица CREATE TABLE `таблица` (
`поле` char(32) character set koi8r NOT NULL default '' COMMENT 'комментарий поля'
) TYPE=MyISAM DEFAULT CHARSET=latin1 COMMENT='комментарий таблицы'
SHOW FIELDS FROM таблица;
Field Type Null Key Default Extra
поле char(32)
SET CHARACTER SET cp1251;
SHOW TABLES;
Tables_in_test
РЮАКХЖЮ
SHOW CREATE TABLE РЮАКХЖЮ;
Table Create Table
РЮАКХЖЮ CREATE TABLE `РЮАКХЖЮ` (
`ОНКЕ` char(32) character set koi8r NOT NULL default '' COMMENT 'ЙНЛЛЕМРЮПХИ ОНКЪ'
) TYPE=MyISAM DEFAULT CHARSET=latin1 COMMENT='ЙНЛЛЕМРЮПХИ РЮАКХЖШ'
SHOW FIELDS FROM РЮАКХЖЮ;
Field Type Null Key Default Extra
ОНКЕ char(32)
SET CHARACTER SET utf8;
SHOW TABLES;
Tables_in_test
я┌п╟п╠п╩п╦я├п╟
SHOW CREATE TABLE я┌п╟п╠п╩п╦я├п╟;
Table Create Table
я┌п╟п╠п╩п╦я├п╟ CREATE TABLE `я┌п╟п╠п╩п╦я├п╟` (
`п©п╬п╩п╣` char(32) character set koi8r NOT NULL default '' COMMENT 'п╨п╬п╪п╪п╣п╫я┌п╟я─п╦п╧ п©п╬п╩я▐'
) TYPE=MyISAM DEFAULT CHARSET=latin1 COMMENT='п╨п╬п╪п╪п╣п╫я┌п╟я─п╦п╧ я┌п╟п╠п╩п╦я├я▀'
SHOW FIELDS FROM я┌п╟п╠п╩п╦я├п╟;
Field Type Null Key Default Extra
п©п╬п╩п╣ char(32)
SET CHARACTER SET koi8r;
DROP TABLE таблица;
SET CHARACTER SET default;
SET CHARACTER SET koi8r;
CREATE DATABASE тест;
USE тест;
SHOW TABLES;
Tables_in_тест
SHOW TABLES IN тест;
Tables_in_тест
SET CHARACTER SET cp1251;
SHOW TABLES;
Tables_in_РЕЯР
SHOW TABLES IN РЕЯР;
Tables_in_РЕЯР
SET CHARACTER SET koi8r;
DROP DATABASE тест;
SET NAMES koi8r;
SELECT hex('тест');
hex('тест')
D4C5D3D4
SET character_set_connection=cp1251;
SELECT hex('тест');
hex('тест')
F2E5F1F2
|
