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/r/date_formats.result | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/r/date_formats.result') diff --git a/mysql-test/r/date_formats.result b/mysql-test/r/date_formats.result index f1582707cf5..fba1d9f47e3 100644 --- a/mysql-test/r/date_formats.result +++ b/mysql-test/r/date_formats.result @@ -364,7 +364,7 @@ str_to_date(a,b) create table t2 select str_to_date(a,b) from t1; describe t2; Field Type Null Key Default Extra -str_to_date(a,b) char(29) YES NULL +str_to_date(a,b) binary(29) YES NULL select str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f") as f1, str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S") as f2, str_to_date("2003-01-02", "%Y-%m-%d") as f3, -- cgit v1.2.1