MySQL字符集和校对顺序

查看所支持的字符集列表

show character set;

查看所支持校对的列表

show collation;

确定所用的字符集和校对

show variables like 'character%';
show variables like 'collation%';

给表指定字符集和校对

create table mytable
(
	columnn1 int;
	columnn2 varchar(10)
)default character set hebrew
 collate hebrew_general_ci;

给列指定字符集和校对

create table mytable
(
	columnn1 int;
	columnn2 varchar(10)
	columnn3 varchar(10) character set latin1 collate latin1_general_ci
)default character set hebrew
 collate hebrew_general_ci;

检索

select * from customers
order by lastname,firstname collate latin1_general_cs;