blob: a4389ff918af62065ee1d4b6219f8a3f302007c2 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
SET NAMES utf8;
create table t1 (a int);
insert into t1 values (1), (2), (11), (12);
create view v1 as
-- Some comment
select a as 'ăș' from t1 where a > 10
-- Another comment with ășîț
order by a
;
SET NAMES latin1;
show create view v1;
--vertical_results
select * from information_schema.views where table_schema = 'test';
SET NAMES utf8;
--vertical_results
select * from information_schema.views where table_schema = 'test';
drop table t1;
drop view v1;
|
