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/t/cast.test | |
| 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/t/cast.test')
| -rw-r--r-- | mysql-test/t/cast.test | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/cast.test b/mysql-test/t/cast.test index 8703a6b739d..59b8f3b0c75 100644 --- a/mysql-test/t/cast.test +++ b/mysql-test/t/cast.test @@ -14,6 +14,15 @@ select cast("2001-1-1" as DATE), cast("2001-1-1" as DATETIME); select cast("1:2:3" as TIME); # +# Character set convertion +# +select cast(_latin1'test' as char character set latin2); +select cast(_koi8r'ΤΕΣΤ' as char character set cp1251); +create table t1 select cast(_koi8r'ΤΕΣΤ' as char character set cp1251) as t; +show create table t1; +drop table t1; + +# # The following should be fixed in 4.1 # |