Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
roxcy
Yak Posting Veteran
58 Posts |
 Posted - 2006-08-17 : 09:53:57
|
| Hi, I am encountering an Error ie "String or binary data Would be truncated" While I am trying to update my table.My Table Name is CMTN ColumnName is IdNo and the value type I have given is nchar(10). Can anyone provide the solution plz..... Thanks ..... |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2006-08-17 : 10:04:23
|
| It means you are trying to fit a string of length X into a column of length X-N. The server won't do that because it would lead to data loss (the end of the string).What is the datatype of the destination column, and what is the datatype (or maximum length) of the data that you are trying to insert? |
 |
|
|
roxcy
Yak Posting Veteran
58 Posts |
Posted - 2006-08-17 : 10:52:29
|
| Even after Increasing the size of the column i am still facing the same error. |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-08-17 : 11:20:19
|
| could u post the table structure and the insert statement.If the insert statement has some values from other tables, give the structure of those as wellSrinika |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-17 : 11:20:53
|
quote:
Originally posted by roxcy
Even after Increasing the size of the column i am still facing the same error.
Post table structure and the query you triedMadhivananFailing to plan is Planning to fail |
|
|
|
jamster.com
Starting Member
1 Post |
Posted - 2008-06-06 : 06:42:32
|
| I have also encounted this problem after correcting the size of the column. I have found that Sql server still thinks the size of the column hasn't changed but when you use sp_help it clearly has. I have posted this on the MSDN site but have still not had any replies.jamster |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 10:39:28
|
quote:
Originally posted by jamster.com
I have also encounted this problem after correcting the size of the column. I have found that Sql server still thinks the size of the column hasn't changed but when you use sp_help it clearly has. I have posted this on the MSDN site but have still not had any replies.jamster
Havent ever experienced that. Have had this error few times before and correcting column size fixed it. |
|
|
|
|
|
|
String or Binary Data Would be Truncated