? values()里面是值,而不是类型长度! insert into tbl1 (col1,col2) values ("111","222")---col1,col2 是字符型时 insert into tbl1 (col1,col2) values (111,222)---col1,col2 是数值型时
MySQL的文档上有提到 As of MySQL 5.0.15, CHAR() arguments larger than 255 are converted into multiple result bytes. For example, CHAR(256) is equivalent to CHAR(1,0), and CHAR(256*256) is equivalent to CHAR(1,0,0): 大于255的参数会转变成多结果字节,例如:char(256)相当于char(1,0),char(256*256)相当于char(1,0,0)我试了一下,发现从129到254好像都会变成“?”
insert into tbl1 (col1,col2) values ("111","222")---col1,col2 是字符型时
insert into tbl1 (col1,col2) values (111,222)---col1,col2 是数值型时
我想知道为什么mysql插入不了ascii >= 128的符号
insert into tbl1 (col1,col2) values ("111","222")---col1,col2 是字符型时
insert into tbl1 (col1,col2) values (111,222)---col1,col2 是数值型时
As of MySQL 5.0.15, CHAR() arguments larger than 255 are converted into multiple result bytes. For example, CHAR(256) is equivalent to CHAR(1,0), and CHAR(256*256) is equivalent to CHAR(1,0,0):
大于255的参数会转变成多结果字节,例如:char(256)相当于char(1,0),char(256*256)相当于char(1,0,0)我试了一下,发现从129到254好像都会变成“?”