diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2003-05-28 17:57:58 +0500 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2003-05-28 17:57:58 +0500 |
| commit | 5f9d3e4276913351a9a8485654657d23b8aa7b6d (patch) | |
| tree | d90c589c4aa4758f8cd2ece67315b1f98e924f3e /mysql-test/r/cast.result | |
| parent | 9166602342853af34ee7f38ae638692e4fcdd46e (diff) | |
| download | mariadb-git-5f9d3e4276913351a9a8485654657d23b8aa7b6d.tar.gz | |
CAST(expr AS char) now supports character set with conversion:
SELECT CAST(_latin1'string' AS CHAR CHARACTER SET latin2)
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 7909fabc971..42164a2111b 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -28,6 +28,19 @@ cast("2001-1-1" as DATE) cast("2001-1-1" as DATETIME) select cast("1:2:3" as TIME); cast("1:2:3" as TIME) 01:02:03 +select cast(_latin1'test' as char character set latin2); +cast(_latin1'test' as char character set latin2) +test +select cast(_koi8r'ΤΕΣΤ' as char character set cp1251); +cast(_koi8r'ΤΕΣΤ' as char character set cp1251) +ςερς +create table t1 select cast(_koi8r'ΤΕΣΤ' as char character set cp1251) as t; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `t` char(4) character set cp1251 NOT NULL default '' +) TYPE=MyISAM CHARSET=latin1 +drop table t1; select cast("2001-1-1" as date) = "2001-01-01"; cast("2001-1-1" as date) = "2001-01-01" 0 |