195,891
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
大家好,请教一下大家一个问题,差了很多的资料都说sqlite 的unsigned tinyint类型是占一个字节,范围0-255,但是为何我可以insert一个超过255的值呢;
sqlite> drop table test;
sqlite>
sqlite> CREATE TABLE test ( id unsigned tinyint);
sqlite> insert into test values(3666);
sqlite> select * from test;
3666
sqlite>
请问下各位,是为什么呢?
SQLite version 3.7.17 2013-05-20 00:56:22