mysql数据库
首先表的创建语句如下：
create table teacher(id int primary key auto_increment,name varchar(40))default charset=utf8;
_mysql中：show variables like 'char%' ;显示如下：
+--------------------------+---------------------------------------------------------------+
| variable_name | value |
+--------------------------+---------------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | c:\program files (x86)\mysql\mysql server 5.0\share\charsets\ |
+--------------------------+---------------------------------------------------------------+
随便插入一个中文数据仍然出现错误，求解。
mysql> insert into teacher values(1,'周');
ERROR 1406 (22001): Data too long for column 'name' at row 1
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
广告Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
918
收藏
取消收藏
