In SQL Server Object Explorer, for a database, I ran Task > Generate Scripts and selected Schema and Data. When I ran the script, two records failed because of truncation. One of them had 201 characters and the other had 205 characters. How is this possible? Both of them seem to have contained line feeds in them. If the line feeds were removed the length shortened and the records entered ok. But how did the original table accommodate the oversized field?
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
205 Characters from VARCHAR(200) Field?
- Thread starter grnzbra
- Start date
- Status
Similar threads
- Locked
- Question