当前位置: 代码迷 >> Sql Server >> 显示字段长度超过255
  详细解决方案

显示字段长度超过255

热度:11   发布时间:2016-04-24 10:23:33.0
求助 显示字段长度超过255
关于数据库字段长度的问题
字段设为 varchar(500),改字符长度为385,但是显示的是 255,求助

该字符的实际
CP02030221/14050940,CP02030021/14010310,CP02030021/14010332,CP02030031/14010305,CP02030031/14010307,CP02030031/14010295,CP02030031/14010308,Y01201307132115,CP02030231/14010117,CP02030231/14010224,001040071403070177,001038071403070139,001040071403070057,001040071403070047,001038071403070107,001038071403070101,001038071403070164,001038071403070035,001038071403070114,001038071403070062

插入表后
CP02030221/14050940,CP02030021/14010310,CP02030021/14010332,CP02030031/14010305,CP02030031/14010307,CP02030031/14010295,CP02030031/14010308,Y01201307132115,CP02030231/14010117,CP02030231/14010224,001040071403070177,001038071403070139,001040071403070057,001

明显缺失了,这个字段怎么修改

------解决方案--------------------
我知道了,数据是对的,只是SSMS的显示有一定限制而已,这个不影响实际存储和前端应用程序使用。

  相关解决方案