← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/default_collation.result

  • Committer: Brian Aker
  • Date: 2009-12-08 23:37:35 UTC
  • mfrom: (1192.3.82 pandora-build)
  • mto: This revision was merged to the branch mainline in revision 1241.
  • Revision ID: brian@gaz-20091208233735-6zfhecyxizlw8bub
Merge range fix

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/default_collation.result
5
5
alter database mysqltest collate = utf8_general_ci;
6
6
show create database mysqltest;
7
7
Database        Create Database
8
 
mysqltest       CREATE DATABASE `mysqltest` COLLATE = utf8_general_ci
 
8
mysqltest       CREATE DATABASE `mysqltest`
9
9
alter database mysqltest collate = utf8_bin;
10
10
show create database mysqltest;
11
11
Database        Create Database
34
34
show create table t1;
35
35
Table   Create Table
36
36
t1      CREATE TABLE `t1` (
37
 
  `a` VARCHAR(10) COLLATE utf8_bin DEFAULT NULL
38
 
) ENGINE=DEFAULT COLLATE = utf8_bin
 
37
  `a` varchar(10) COLLATE utf8_bin DEFAULT NULL
 
38
) ENGINE=InnoDB
39
39
show create table t2;
40
40
Table   Create Table
41
41
t2      CREATE TABLE `t2` (
42
 
  `a` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
43
 
) ENGINE=DEFAULT COLLATE = utf8_general_ci
 
42
  `a` varchar(10) DEFAULT NULL
 
43
) ENGINE=InnoDB
44
44
select count(*) from t1 where a='a';
45
45
count(*)
46
46
1