《MysqL教程探究MysqL中varchar的定义长度》要点:
本文介绍了MysqL教程探究MysqL中varchar的定义长度,希望对您有用。如果有疑问,可以联系我们。
sql>create table test(id int auto_increment,name varchar(10),primary key(id));
sql>insert into test values(null,'1234567890');
Query OK,1 row affected (0.00 sec)
sql>insert into test values(null,'一二三四五六七八九十');
Query OK,'abcdefghig');
Query OK,1 row affected (0.01 sec)
sql>insert into test values(null,12345678901);
ERROR 1406 (22001): Data too long for column 'name' at row 1
sql>insert into test values(null,'一二三四五六七八九十1');
ERROR 1406 (22001): Data too long for column 'name' at row 1
sql>insert into test values(null,'一二三四五六七八九十一');
ERROR 1406 (22001): Data too long for column 'name' at row 1
sql>select id,name,length(name),char_length(name) from test;
+----+--------------------------------+--------------+-------------------+
| id | name | length(name) | char_length(name) |
+----+--------------------------------+--------------+-------------------+
| 1 | 1234567890 | 10 | 10 |
| 2 | 一二三四五六七八九十 | 30 | 10 |
| 3 | abcdefghig | 10 | 10 |
+----+--------------------------------+--------------+-------------------+
3 rows in set (0.00 sec)
sql>create table test(id int auto_increment,char_length(name) from test;
+----+----------------------+--------------+-------------------+
| id | name | length(name) | char_length(name) |
+----+----------------------+--------------+-------------------+
| 1 | 1234567890 | 10 | 10 |
| 2 | 一二三四五六七八九十 | 20 | 10 |
| 3 | abcdefghig | 10 | 10 |
+----+----------------------+--------------+-------------------+
3 rows in set (0.00 sec)
中文和英文字母都被当作1个字符来对待.
MysqL5中varchar的长度也为字符,而MysqL4中的则为字节,未经证实,感兴趣的有环境可以自己测下.
sql>create table test(id int auto_increment,name char(5),primary key(id));
Query OK,0 rows affected (0.09 sec)
sql>insert into test values(null,'123');
Query OK,'12345');
Query OK,'一二三');
Query OK,'一二三四五');
Query OK,123456);
ERROR 1406 (22001): Data too long for column 'name' at row 1
sql>insert into test values(null,'一二三四五1');
ERROR 1406 (22001): Data too long for column 'name' at row 1
sql>select id,char_length(name) from test;
+----+-----------------+--------------+-------------------+
| id | name | length(name) | char_length(name) |
+----+-----------------+--------------+-------------------+
| 1 | 123 | 3 | 3 |
| 2 | 12345 | 5 | 5 |
| 3 | 一二三 | 9 | 3 |
| 4 | 一二三四五 | 15 | 5 |
+----+-----------------+--------------+-------------------+
4 rows in set (0.00 sec)
总结
如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您喜欢交流学习经验,点击链接加入交流1群:1065694478(已满)交流2群:163560250