Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

text string overflow

Status
Not open for further replies.

Aneet

Programmer
Jun 28, 2001
1
CA
Hi If a text string that is input in a column is larger than the field length of the column, is there any way we can set up preferences that will either discard the rest of the of the string or create an error.
Thanks
 
SQL 7 and 2000 will fail on inserts and updates the try to put more data in the column than the column will hold - string or binary data. Previous versions simply truncated the data and proceeded as though everything was fine. Terry

"I shall try to correct errors when shown to be errors, and I shall adopt new views so fast as they shall appear to be true views." - Abraham Lincoln
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top