diff options
Diffstat (limited to 'mysql-test/include/world_schema1.inc')
-rw-r--r-- | mysql-test/include/world_schema1.inc | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/include/world_schema1.inc b/mysql-test/include/world_schema1.inc index 172e79a7c8c..48448b5c1d8 100644 --- a/mysql-test/include/world_schema1.inc +++ b/mysql-test/include/world_schema1.inc @@ -4,15 +4,15 @@ CREATE TABLE Country ( SurfaceArea float(10,2) NOT NULL default '0.00', Population int(11) NOT NULL default '0', Capital int(11) default NULL -); +) COLLATE latin1_bin; CREATE TABLE City ( ID int(11) NOT NULL, Name char(35) NOT NULL default '', Country char(3) NOT NULL default '', Population int(11) NOT NULL default '0' -); +) COLLATE latin1_bin; CREATE TABLE CountryLanguage ( Country char(3) NOT NULL default '', Language char(30) NOT NULL default '', Percentage float(3,1) NOT NULL default '0.0' -); +) COLLATE latin1_bin; |