DROP TABLE IF EXISTS t1;
set names latin1;
set @@collation_connection=latin1_danish_ci;
create table t1 (s1 char(5) character set latin1) COLLATE=latin1_danish_ci;
insert into t1 values ('æ'),('ø'),('å');
select s1,hex(s1),length(s1) from t1 order by s1;
s1	hex(s1)	length(s1)
å	E5	1
æ	E6	1
ø	F8	1
show variables like 'coll%';
Variable_name	Value
collation_connection	latin1_danish_ci
collation_database	latin1_swedish_ci
collation_server	latin1_swedish_ci