← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/backup_charsets.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/backup_charsets.result
 
1
DROP DATABASE IF EXISTS backup_cs;
 
2
CREATE DATABASE backup_cs;
 
3
USE backup_cs;
 
4
SET NAMES utf8;
 
5
CREATE TABLE `ｱｱｱ`(`ｷｷｷ` char(5))
 
6
ENGINE = MEMORY
 
7
DEFAULT CHARSET = utf8;
 
8
SHOW TABLES;
 
9
Tables_in_backup_cs
 
10
ｱｱｱ
 
11
SHOW CREATE TABLE `ｱｱｱ`;
 
12
Table   Create Table
 
13
ｱｱｱ     CREATE TABLE `ｱｱｱ` (
 
14
  `ｷｷｷ` char(5) DEFAULT NULL
 
15
) ENGINE=MEMORY DEFAULT CHARSET=utf8
 
16
INSERT INTO `ｱｱｱ` VALUES ("ｱｱｱ");
 
17
BACKUP DATABASE backup_cs TO "backup_cs.bak";
 
18
backup_id
 
19
#
 
20
DROP DATABASE backup_cs;
 
21
RESTORE FROM "backup_cs.bak";
 
22
backup_id
 
23
#
 
24
USE backup_cs;
 
25
SHOW CREATE TABLE `ｱｱｱ`;
 
26
Table   Create Table
 
27
ｱｱｱ     CREATE TABLE `ｱｱｱ` (
 
28
  `ｷｷｷ` char(5) DEFAULT NULL
 
29
) ENGINE=MEMORY DEFAULT CHARSET=utf8
 
30
SELECT * FROM `ｱｱｱ`;
 
31
ｷｷｷ
 
32
ｱｱｱ
 
33
SET NAMES latin2;
 
34
DROP DATABASE backup_cs;
 
35
RESTORE FROM "backup_cs.bak";
 
36
backup_id
 
37
#
 
38
SHOW TABLES IN backup_cs;
 
39
Tables_in_backup_cs
 
40
???
 
41
SELECT @@character_set_client;
 
42
@@character_set_client
 
43
latin2
 
44
SELECT @@character_set_results;
 
45
@@character_set_results
 
46
latin2
 
47
SELECT @@character_set_connection;
 
48
@@character_set_connection
 
49
latin2
 
50
DROP DATABASE backup_cs;