How to change the default collation of a table?

create table check2(f1 varchar(20),f2 varchar(20)); creates a table with the default collation `latin1_general_ci`; alter table check2 collate latin1_general_cs; show full columns from check2; shows the individual collation of the columns as 'latin1_general_ci'. Then what is the effect of the alter table command?