我该如何使MySQL的SELECT DISTINCT区分大小写?
create temporary table X (name varchar(50) NULL);
insert into X values ('this'), ('This');
现在这个查询:
select distinct(name) from X;
结果为:
this
这是怎么回事?我想让SELECT DISTINCT区分大小写。难道这不应该是默认设置吗?
我该如何使MySQL的SELECT DISTINCT区分大小写?
create temporary table X (name varchar(50) NULL);
insert into X values ('this'), ('This');
现在这个查询:
select distinct(name) from X;
结果为:
this
这是怎么回事?我想让SELECT DISTINCT区分大小写。难道这不应该是默认设置吗?
SELECT DISTINCT NAME COLLATE latin1_bin FROM X;
- ishmaelcreate table X (name VARCHAR(128) CHARACTER SET utf8 COLLATE utf8_bin NULL);
insert into X values ('this'), ('This');
SQLFiddle: http://sqlfiddle.com/#!2/add276/2/0