MySQL大小写问题

| Database | Create Database                                                                 |

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

| testx    | CREATE DATABASE `testx` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */ |

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

1 row in set (0.00 sec)

case2是默认创建的表

mysql> show create table case2;

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

| Table | Create Table                                                                                                           |

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

| case2 | CREATE TABLE `case2` (

`a` int(11) DEFAULT NULL,

`B` varchar(10) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

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

1 row in set (0.00 sec)

case4是指定字符集和collate的表

mysql> create table case4(a int(11),B varchar(10)) default character set utf8 collate utf8_bin;;

Query OK, 0 rows affected (0.12 sec)

mysql> show create table case4;

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

（编辑：西安站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!