VB & Database, ADO SQL Server update of long strings

ADO SQL Server update of long strings

Author	Message
Charles Sugde #1 / 6	ADO SQL Server update of long strings I am performing an embedded SQL update of a record that has a 3000 byte column within it. The update fails with the message "String or binary data would be truncated." I finally got the update statement to succeed when a cut downn the string to 1000 bytes. Does anybody know why this is happening?
Mon, 07 Mar 2005 03:15:33 GMT

Val Mazu #2 / 6	ADO SQL Server update of long strings Hi, It could be a limit on length of query. Which version of SQL Server are you using? -- Val Mazur Microsoft MVP Quote: > I am performing an embedded SQL update of a record that > has a 3000 byte column within it. The update fails with > the message > "String or binary data would be truncated." > I finally got the update statement to succeed when a cut > downn the string to 1000 bytes. > Does anybody know why this is happening?
Mon, 07 Mar 2005 03:27:49 GMT

Charles Sugde #3 / 6	ADO SQL Server update of long strings SQL Server 2000 SP1 I heard there was some sort of memory leak bug with strings over 16k. I'm gonna research it, but strangely enough, when I pared down the length of the enbedded sql statement, ie. "update mytable set notes=trim(" & left (txtnotes.text,1000) & " where ..." It could only use 1000, not one byte more. Quote: >-----Original Message----- >Hi, >It could be a limit on length of query. Which version of SQL Server are you >using? >-- >Val Mazur >Microsoft MVP message >> I am performing an embedded SQL update of a record that >> has a 3000 byte column within it. The update fails with >> the message >> "String or binary data would be truncated." >> I finally got the update statement to succeed when a cut >> downn the string to 1000 bytes. >> Does anybody know why this is happening? >.
Mon, 07 Mar 2005 22:48:47 GMT

Charles Sugde #4 / 6	ADO SQL Server update of long strings I found out some things: 1. I extracted the code into Query Analyzer and tried it there. It failed with the same error. So, it seems to be saying that you should be using varchar strings over 1024 bytes. 2. I redefined the column as a 'text' datatype and everything works fine. Thanks for listening Quote: >-----Original Message----- >Hi, >It could be a limit on length of query. Which version of SQL Server are you >using? >-- >Val Mazur >Microsoft MVP message >> I am performing an embedded SQL update of a record that >> has a 3000 byte column within it. The update fails with >> the message >> "String or binary data would be truncated." >> I finally got the update statement to succeed when a cut >> downn the string to 1000 bytes. >> Does anybody know why this is happening? >.
Tue, 08 Mar 2005 00:37:44 GMT

Val Mazu #5 / 6	ADO SQL Server update of long strings Hi, Limit for varchar/char data type in SQL Server 7 and 2000 is 8000 characters. It should work fine. I think problem is in something else -- Val Mazur Microsoft MVP Quote: > I found out some things: > 1. I extracted the code into Query Analyzer and tried it > there. It failed with the same error. So, it seems to be > saying that you should be using varchar strings over 1024 > bytes. > 2. I redefined the column as a 'text' datatype and > everything works fine. > Thanks for listening > >-----Original Message----- > >Hi, > >It could be a limit on length of query. Which version of > SQL Server are you > >using? > >-- > >Val Mazur > >Microsoft MVP > message > >> I am performing an embedded SQL update of a record that > >> has a 3000 byte column within it. The update fails with > >> the message > >> "String or binary data would be truncated." > >> I finally got the update statement to succeed when a cut > >> downn the string to 1000 bytes. > >> Does anybody know why this is happening? > >.
Tue, 08 Mar 2005 01:10:46 GMT

Charles Sugde #6 / 6	ADO SQL Server update of long strings Finally figured it out. I had a trigger behind the table update and the column on the journal file was 1024 bytes....duh Quote: >-----Original Message----- >Hi, >It could be a limit on length of query. Which version of SQL Server are you >using? >-- >Val Mazur >Microsoft MVP message >> I am performing an embedded SQL update of a record that >> has a 3000 byte column within it. The update fails with >> the message >> "String or binary data would be truncated." >> I finally got the update statement to succeed when a cut >> downn the string to 1000 bytes. >> Does anybody know why this is happening? >.
Tue, 08 Mar 2005 01:31:22 GMT

Page 1 of 1

[ 6 post ]