mysql列不区分大小写_我可以使mysql表列不区分大小写吗？

默认情况下,

MySQL不区分大小写.

CREATE TABLE test

(

name VARCHAR(20),

UNIQUE(name)

);

mysql> INSERT INTO test VALUES('California');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO test VALUES('california');

ERROR 1062 (23000): Duplicate entry 'california' for key 'name'

mysql> INSERT INTO test VALUES('cAlifornia');

ERROR 1062 (23000): Duplicate entry 'cAlifornia' for key 'name'

mysql> INSERT INTO test VALUES('cALifornia');

ERROR 1062 (23000): Duplicate entry 'cALifornia' for key 'name'

mysql> SELECT * FROM test;

+------------+

| name |

+------------+

| California |

+------------+

1 row in set (0.00 sec)

需要区分大小写时使用BINARY

要在MySQL中区分大小写,请使用BINARY关键字,如下所示

mysql> CREATE TABLE test

-> (

-> name varchar(20) BINARY,

-> UNIQUE(name)

-> );

Query OK, 0 rows affected (0.00 sec)

mysql>

mysql> INSERT INTO test VALUES('California');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> INSERT INTO test VALUES('california');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO test VALUES('cAlifornia');

Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO test VALUES('cALifornia');

Query OK, 1 row affected (0.00 sec)

mysql>

mysql> SELECT * FROM test;

+------------+

| name |

+------------+

| California |

| cALifornia |

| cAlifornia |

| california |

+------------+

4 rows in set (0.00 sec)