From 3eff43162ba3136ecd305534f1e9d7cc779ce301 Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 26 Mar 2004 16:11:46 +0400 Subject: 1. New data types, from the user point of view: BINARY(N) and VARBIBARY(N) 2. More 4.0 compatibility and more BINARY keyword consistency: 2a. CREATE TABLE a (a CHAR(N) BINARY) is now synonym for CREATE TABLE a (a CHAR(N) COLLATE xxxx_bin) 2b. SELECT BINARY x is still synonin for SELECT x COLLATE xxxxx_bin. --- mysql-test/t/alter_table.test | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/t/alter_table.test') diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 39c84eceb94..9235496b45c 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -193,7 +193,7 @@ insert into t1 values (' select a,hex(a) from t1; alter table t1 change a a char(10) character set cp1251; select a,hex(a) from t1; -alter table t1 change a a char(10) binary; +alter table t1 change a a binary(10); select a,hex(a) from t1; alter table t1 change a a char(10) character set cp1251; select a,hex(a) from t1; -- cgit v1.2.1