diff options
| author | unknown <bar@mysql.com> | 2005-02-18 16:10:12 +0400 |
|---|---|---|
| committer | unknown <bar@mysql.com> | 2005-02-18 16:10:12 +0400 |
| commit | cfa78c2645d3a0c3eaf02a256f63d2d284ed2b3b (patch) | |
| tree | 53799b508e8232f507f797d3f2a74934878591a0 /mysql-test/r/ctype_latin1_de.result | |
| parent | 5b91c5a73c778bd0e93220534493bacaba0c292c (diff) | |
| download | mariadb-git-cfa78c2645d3a0c3eaf02a256f63d2d284ed2b3b.tar.gz | |
Bug #7878 with utf_general_ci, equals (=) has problem with accent insensitivity
Backporting Monty's fix for 5.0 into 4.1.
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 6df9d963498..f57d8c191bf 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; |