--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

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;

show variables like 'coll%';