~vkolesnikov/pbxt/pbxt-07-diskfull

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/t/ctype_gb2312.test

  • Committer: paul-mccullagh
  • Date: 2006-10-23 09:14:04 UTC
  • Revision ID: paul-mccullagh-918861e03d351978a9541168a96e58cc826734ee
Initial import

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
-- source include/have_gb2312.inc
 
2
 
 
3
#
 
4
# Tests with the gb2312 character set
 
5
#
 
6
--disable_warnings
 
7
drop table if exists t1;
 
8
--enable_warnings
 
9
 
 
10
SET @test_character_set= 'gb2312';
 
11
SET @test_collation= 'gb2312_chinese_ci';
 
12
-- source include/ctype_common.inc
 
13
 
 
14
SET NAMES gb2312;
 
15
SET collation_connection='gb2312_chinese_ci';
 
16
-- source include/ctype_filesort.inc
 
17
-- source include/ctype_innodb_like.inc
 
18
-- source include/ctype_like_escape.inc
 
19
SET collation_connection='gb2312_bin';
 
20
-- source include/ctype_filesort.inc
 
21
-- source include/ctype_innodb_like.inc
 
22
-- source include/ctype_like_escape.inc
 
23
 
 
24
#
 
25
# Bug#15377 Valid multibyte sequences are truncated on INSERT
 
26
#
 
27
SET NAMES gb2312;
 
28
CREATE TABLE t1 (a text) character set gb2312;
 
29
INSERT INTO t1 VALUES (0xA2A1),(0xD7FE);
 
30
SELECT hex(a) FROM t1 ORDER BY a;
 
31
DROP TABLE t1;
 
32
 
 
33
# End of 4.1 tests