diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2003-08-12 16:42:52 +0500 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2003-08-12 16:42:52 +0500 |
| commit | 2338e2eaf9392ece5faea1f19147d4402590314d (patch) | |
| tree | 117030028f954681de7ca7e02d98352a54512e88 /mysql-test/t/func_like.test | |
| parent | 253b2a9654f6430d879076771b70bd018dd30732 (diff) | |
| download | mariadb-git-2338e2eaf9392ece5faea1f19147d4402590314d.tar.gz | |
LIKE didn't work with non-default charset
Diffstat (limited to 'mysql-test/t/func_like.test')
| -rw-r--r-- | mysql-test/t/func_like.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/func_like.test b/mysql-test/t/func_like.test index 90b376e34df..0cd85385df4 100644 --- a/mysql-test/t/func_like.test +++ b/mysql-test/t/func_like.test @@ -24,3 +24,23 @@ select * from t1 where a like "%abcd%"; select * from t1 where a like "%abc\d%"; drop table t1; + + +# +# Test like with non-default character set +# + +SET NAMES koi8r; + +CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET koi8r); + +INSERT INTO t1 VALUES ('ÆÙ×Á'),('æÙ×Á'),('Æù×Á'),('ÆÙ÷Á'),('ÆÙ×á'),('æù÷á'); +INSERT INTO t1 VALUES ('ÆÙ×ÁÐÒÏÌÄÖ'),('æÙ×ÁÐÒÏÌÄÖ'),('Æù×ÁÐÒÏÌÄÖ'),('ÆÙ÷ÁÐÒÏÌÄÖ'); +INSERT INTO t1 VALUES ('ÆÙ×áÐÒÏÌÄÖ'),('ÆÙ×ÁðÒÏÌÄÖ'),('ÆÙ×ÁÐòÏÌÄÖ'),('ÆÙ×ÁÐÒïÌÄÖ'); +INSERT INTO t1 VALUES ('ÆÙ×ÁÐÒÏìÄÖ'),('ÆÙ×ÁÐÒÏÌäÖ'),('ÆÙ×ÁÐÒÏÌÄö'),('æù÷áðòïìäö'); + +SELECT * FROM t1 WHERE a LIKE '%Æù×Á%'; +SELECT * FROM t1 WHERE a LIKE '%Æù×%'; +SELECT * FROM t1 WHERE a LIKE 'Æù×Á%'; + +DROP TABLE t1; |