← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/r/ctype_ucs.result

  • Committer: Mark Callaghan
  • Date: 2008-10-25 15:34:00 UTC
  • mfrom: (2736.1.36 mysql-5.1)
  • Revision ID: mdcallag@gmail.com-20081025153400-uigkz0tk1nxwb13b
merge from 5.1

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/ctype_ucs.result
1098
1098
select * from t1 where a=if(b<10,_ucs2 0x0062,_ucs2 0x00C0);
1099
1099
ERROR HY000: Illegal mix of collations (ascii_general_ci,IMPLICIT) and (ucs2_general_ci,COERCIBLE) for operation '='
1100
1100
drop table t1;
 
1101
CREATE TABLE t1 (s1 CHAR(5) CHARACTER SET UCS2);
 
1102
INSERT INTO t1 VALUES ('a');
 
1103
SET @@sql_mode=pad_char_to_full_length;
 
1104
SELECT HEX(s1) FROM t1;
 
1105
HEX(s1)
 
1106
00610020002000200020
 
1107
SET @@sql_mode=default;
 
1108
SELECT HEX(s1) FROM t1;
 
1109
HEX(s1)
 
1110
0061
 
1111
DROP TABLE t1;
1101
1112
set collation_connection=ucs2_general_ci;
1102
1113
drop table if exists t1;
1103
1114
create table t1 as