diff options
| author | unknown <bar@mysql.com> | 2005-02-18 16:14:28 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2005-02-18 16:14:28 +0400 |
| commit | c30f658275278c9d6bc047f376e339b22f1342cb (patch) | |
| tree | 7961bf2d0ca3998c6361d9abf284c182d5e755ce /mysql-test/r/ctype_latin1_de.result | |
| parent | 3429ad82349335aa9d8dffcfce4288e25f9579d0 (diff) | |
| parent | cfa78c2645d3a0c3eaf02a256f63d2d284ed2b3b (diff) | |
| download | mariadb-git-c30f658275278c9d6bc047f376e339b22f1342cb.tar.gz | |
Merge mysql.com:/usr/home/bar/mysql-4.1
into mysql.com:/usr/home/bar/mysql-5.0.fresh
include/my_base.h:
Auto merged
myisam/mi_rnext_same.c:
Auto merged
mysql-test/r/ctype_latin1_de.result:
Auto merged
Diffstat (limited to 'mysql-test/r/ctype_latin1_de.result')
| -rw-r--r-- | mysql-test/r/ctype_latin1_de.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_latin1_de.result b/mysql-test/r/ctype_latin1_de.result index f9deca3a771..5e885d006cb 100644 --- a/mysql-test/r/ctype_latin1_de.result +++ b/mysql-test/r/ctype_latin1_de.result @@ -326,3 +326,15 @@ latin1_german2_ci 6109 latin1_german2_ci 61 latin1_german2_ci 6120 drop table t1; +SET NAMES latin1; +CREATE TABLE t1 ( +col1 varchar(255) NOT NULL default '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1 collate latin1_german2_ci; +INSERT INTO t1 VALUES ('ß'),('ss'),('ss'); +ALTER TABLE t1 ADD KEY ifword(col1); +SELECT * FROM t1 WHERE col1='ß' ORDER BY col1, BINARY col1; +col1 +ss +ss +ß +DROP TABLE t1; |