MySQL在做字符串比较时(比如密码),发现大小写是不区分的。
这与字段的编码有关。
CREATE
TABLE
`vpromanage`.`user_info` (
`userName` char ( 20 ) character set utf8 collate utf8_bin NOT NULL ,
`password` char ( 20 ) character set utf8 collate utf8_bin NOT NULL ,
`userType` enum( ' General ' , ' Advanced ' , ' Admin ' ) NOT NULL ,
PRIMARY KEY (`userName`),
KEY `FK_uerType` (`userType`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
`userName` char ( 20 ) character set utf8 collate utf8_bin NOT NULL ,
`password` char ( 20 ) character set utf8 collate utf8_bin NOT NULL ,
`userType` enum( ' General ' , ' Advanced ' , ' Admin ' ) NOT NULL ,
PRIMARY KEY (`userName`),
KEY `FK_uerType` (`userType`)
) ENGINE = InnoDB DEFAULT CHARSET = utf8;
collate 编码 带 "_bin"的是区分字符大小写的。