問題描述
字符串或二進制數據將被截斷 (string or binary data would be truncated)
I had web page where I add update to data in it it worked well later and when I add data today I had this error string or binary data would be truncated ..... although I tested that on other PC and this error didnot apear again so what the a problem.
參考解法
方法 1:
That's the error message you get, if you attempt to enter data that is longer than the underlying 'backing' column in a database.
[It seems likely you entered different data on the two PC's you tested on]
方法 2:
You get an error like this if you try to put a too long string in a database column, like "abcd" in varchar(3).
(by Myworld、Mitch Wheat、fejesjoco)