191
191
or DATA_TYPE = 'varchar')
192
192
group by DATA_TYPE order by DATA_TYPE, num;
197
197
create table t1(f1 char(1) not null, f2 char(9) not null);
198
198
select CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH from
199
199
data_dictionary.columns where table_schema='test' and table_name = 't1';