CHAR
简介
校验字符串长度。
示例
数据字典
hrm.departments 人力资源系统-部门表
列名 | 数据类型 | 非空 | 自增 | 键 | 描述 |
---|---|---|---|---|---|
dept_no | char(4) | 是 | - | 主键 | 部门唯一编号 |
dept_name | varchar(40) | 是 | - | 唯一键 | 部门名称 |
如上表中,部门编号字 段dept_no是char类型,且长度不超过4个
示例
dept_no字段的值为超过最大长度4的字符串
luwak请求
POST http://127.0.0.1:21000
Content-Type: application/json;charset=utf-8
{
"jsonrpc": "2.0",
"method": "hrm.departments.add",
"params": {
"deptNo": "d12345",
"deptName": "Human Resources"
},
"id": "client-unique-request-id"
}
响应结果
请求被拦截,报错,提示插入的数据超过了字段类型的最大长 度。
HTTP/1.1 400 Bad Request
Content-Type: application/json; charset=utf-8
{
"jsonrpc": "2.0",
"error": {
"code": -32602,
"message": "validating data type: deptNo: d1235 does not validate as maxstringlength(4)",
"data": {
"errorCode": "EU.Validator.DataTypeError",
"errorDetails": [
{
"field": "deptNo",
"fieldValue": "d1235",
"location": "hrm.departments",
"message": "deptNo: d1235 does not validate as maxstringlength(4)",
"validator": "maxstringlength"
}
],
"errorMessage": "deptNo: d1235 does not validate as maxstringlength(4)"
}
},
"id": "client-unique-request-id"
}
备注: 以上示例在Luwak 1.12.9测试通过。