有什么办法可以使Mysql 5.1.x中的UNIQUE索引不区分大小写? [英] Is there any way to make a UNIQUE index case insensitive in Mysql 5.1.x ?

问题描述

如果是-此表中必须更改什么?

If so - What must change in this table ?

CREATE TABLE  contestants 
( 
  idContestants  int(10) unsigned NOT NULL AUTO_INCREMENT,
  idEvent        int(10) unsigned NOT NULL,
  ContestantName  varchar(50) DEFAULT NULL,
  PRIMARY KEY (idContestants),
  UNIQUE KEY Index_UniqueName (idEvent,ContestantName),
)
ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

推荐答案

如果您要区分大小写，则:

If you mean case sensitive then:

ALTER TABLE `contestants` CHANGE `ContestantName` `ContestantName` VARCHAR( 50 )
CHARACTER SET latin1 COLLATE latin1_bin NULL DEFAULT NULL 

如果您不区分大小写，则:

If you mean case insensitive then:

ALTER TABLE `contestants` CHANGE `ContestantName` `ContestantName` VARCHAR( 50 )
CHARACTER SET latin1 COLLATE latin1_general_ci NULL DEFAULT NULL 

对于表级别，请执行(不区分大小写):

For table level do (for case insensitive):

ALTER TABLE `contestants` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci

请注意，表级别仅影响新列.

Note that table level only affects new columns.

对于数据库级别，请执行(不区分大小写):

For database level do (for case insensitive):

ALTER DATABASE `database_name` CHARACTER SET latin1 COLLATE latin1_general_ci

请注意，数据库级别仅影响新表.

Note that database level only affect new tables.

这篇关于有什么办法可以使Mysql 5.1.x中的UNIQUE索引不区分大小写?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！