diff options
author | unknown <bar@mysql.com> | 2004-10-29 16:00:03 +0500 |
---|---|---|
committer | unknown <bar@mysql.com> | 2004-10-29 16:00:03 +0500 |
commit | a739f2d692093accfb5babf3df9008913fdf5d3f (patch) | |
tree | b66152e6af71b2839f39170b311d5e915b5937c6 /mysql-test/r/ctype_recoding.result | |
parent | facda8f3ef9cbc7ca3aecd06c2477f8de27d166c (diff) | |
download | mariadb-git-a739f2d692093accfb5babf3df9008913fdf5d3f.tar.gz |
Allow to convert to non-Unicode charset when mixing a string
constant with a column. The string is converted into the column
character set. It conversion doesn't lose data, then operation
is possible. Otherwise, give an error, as it was earlier.
sql/item.h:
Change bool argument to uint flags:
we have now two different flags.
Diffstat (limited to 'mysql-test/r/ctype_recoding.result')
-rw-r--r-- | mysql-test/r/ctype_recoding.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/ctype_recoding.result b/mysql-test/r/ctype_recoding.result index 72d19885101..dc1f4c12e25 100644 --- a/mysql-test/r/ctype_recoding.result +++ b/mysql-test/r/ctype_recoding.result @@ -174,3 +174,15 @@ Warnings: Warning 1265 Data truncated for column 'a' at row 1 Warning 1265 Data truncated for column 'b' at row 1 drop table t1; +set names koi8r; +create table t1 (a char(10) character set cp1251); +insert into t1 values (_koi8r'×ÁÓÑ'); +select * from t1 where a=_koi8r'×ÁÓÑ'; +a +×ÁÓÑ +select * from t1 where a=concat(_koi8r'×ÁÓÑ'); +ERROR HY000: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (koi8r_general_ci,COERCIBLE) for operation '=' +select * from t1 where a=_latin1'×ÁÓÑ'; +ERROR HY000: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' +drop table t1; +set names latin1; |