diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2003-07-14 18:00:27 +0500 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2003-07-14 18:00:27 +0500 |
| commit | e7360f4989055695b845b757f0ae04709582b24a (patch) | |
| tree | 8a3fcab12360bd7e7541bce2001e4a374434be59 /mysql-test/r/alter_table.result | |
| parent | f1e3a929e844d13bd1e2e51aba19ccc0ea5659a5 (diff) | |
| download | mariadb-git-e7360f4989055695b845b757f0ae04709582b24a.tar.gz | |
A test for character conversion in ALTER TABLE was added
Diffstat (limited to 'mysql-test/r/alter_table.result')
| -rw-r--r-- | mysql-test/r/alter_table.result | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/mysql-test/r/alter_table.result b/mysql-test/r/alter_table.result index cb11e680910..7fa5a0f601f 100644 --- a/mysql-test/r/alter_table.result +++ b/mysql-test/r/alter_table.result @@ -281,3 +281,42 @@ ALTER TABLE t1 DISABLE KEYS; INSERT DELAYED INTO t1 VALUES(1),(2),(3); ALTER TABLE t1 ENABLE KEYS; drop table t1; +set names koi8r; +create table t1 (a char(10) character set koi8r); +insert into t1 values ('ΤΕΣΤ'); +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ D4C5D3D4 +alter table t1 change a a char(10) character set cp1251; +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ F2E5F1F2 +alter table t1 change a a char(10) binary; +select a,hex(a) from t1; +a hex(a) +ςερς F2E5F1F2 +alter table t1 change a a char(10) character set cp1251; +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ F2E5F1F2 +alter table t1 change a a char(10) character set koi8r; +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ D4C5D3D4 +alter table t1 change a a varchar(10) character set cp1251; +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ F2E5F1F2 +alter table t1 change a a char(10) character set koi8r; +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ D4C5D3D4 +alter table t1 change a a text character set cp1251; +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ F2E5F1F2 +alter table t1 change a a char(10) character set koi8r; +select a,hex(a) from t1; +a hex(a) +ΤΕΣΤ D4C5D3D4 +drop table t1; |