mysql binary

[xiaopeng163]

问题描述

老师您好，

我在使用BINARY关键字创建表的时候，有一条Warning，看起来似乎这种方法在以后的新版本用不了了。我这边MySQL的版本号是Ver 8.0.36-0ubuntu0.22.04.1 for Linux on x86_64 ((Ubuntu))

mysql> create table test2(name VARCHAR(10) BINARY, age INT);
Query OK, 0 rows affected, 1 warning (0.05 sec)

mysql> show warnings;
+---------+------+------------------------------------------------------------------------------------------------------------------------------------------------------+
| Level | Code | Message
|
+---------+------+------------------------------------------------------------------------------------------------------------------------------------------------------+
| Warning | 1287 | 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead |
+---------+------+------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
0 个答案
消息

问题发生在第几章第几节

补充：LIKE字符匹配时的大小写敏感问题

有解决办法么？

No response

测试用的Mysql版本

No response